Earlier releases of SQL Server have only one built-in auditing feature: the ability to capture server logins. Under SQL Server 7.0, for example, you can specify that logins — both successful and ...

One of the interesting new features in SQL Server 2008 is Change Data Capture. I wrote about Change Tracking in a previous blog entry. That will track the what, when and who but will not tell you ...

To see the longest running transaction on your SQL Server instance, run the following statement. DBCC OPENTRAN. If there are open transactions, DBCC OPENTRAN will provide a session_id ...