Auditing in SQL Server 2008

Auditing is a new feature introduced in SQL Server 2008. Auditing is a general word and its related to sql server to capture events that occurs in sql server, it’s similar to tracking the processes happening in sql server. This feature helps database administrators to implement a strategy to know who is performing what or… Continue reading Auditing in SQL Server 2008

List Orphan ID’s

This script displays the list of orphan SQL Server accounts from all the databases. This script is applicable for version greater than SQL 2000.