Tag Archives: sql

Change Database Owner with SQL Server Management Studio

What is the database owner? The database owner is a user that has permissions to perform all activities in a database. On a SQL server, database owners can be changed. Any user that …

Tags: , , , , , , , , , , , , , , , , , , , , | Posted under DotNet/Windows Hosting, MSSQL | Leave a comment

Database Diagrams with SQL Server Management Studio

Database Diagrams lets us see the relationship between entities in a database. In this article I will give you a step-by-step guide on how to Create a New Database Diagram with …

Tags: , , , , , , , , , , , , , , , , , , , , , , | Posted under ASP .NET 2, MSSQL, WebsitePanel Tutorials, Windows Server Admin | Leave a comment

Determine the Last Time a SQL Trigger was Used

In SQL 2008 and higher there is a new feature that can help audit triggers. By running the script below you can get some important information about triggers that are …

Tags: , , , , , , , , , , | Posted under Programming/Coding | Leave a comment