In order to ensure consistency, you need to run the DBCC CHECKDB SQL Server command regularly. I'll talk more about CHECKDB later in this article. First, let's talk about database corruption.

DBCC INPUTBUFFER (spid) –from DBCC OPENTRAN Alternatively, you can use a dynamic management view included in SQL Server 2005 to return the SQL statement: ...

• DBCC, SQL Server’s internal consistency checking utility, scales up by seven times. And that improvement happens despite having much additional consistency and logical checks.