SQL @@TOTAL_ERRORS

SQL @@TOTAL_ERRORS is a System Statistical Function, which will return the total number of disk errors since the last time the SQL server started. The syntax behind this is @@TOTAL_ERRORS is

@@TOTAL_ERRORS

SQL @@TOTAL_ERRORS Example

This example code will show you the total number of disk errors for this SQL Server. Learn more about SQL GETDATE from our SQL tutorial page.

SELECT @@TOTAL_ERRORS AS [Total Number of Errors]
SQL @@TOTAL_ERRORS Example 1

Use the GETDATE() along with the TOTAL_ERRORS function to see the total disk errors until today. Please refer to the SQL @@TOTAL_READ and SQL @@TOTAL_WRITE articles.

SELECT @@TOTAL_ERRORS AS [Total Number of Errors],
	GETDATE() AS [As of Today]
SQL @@TOTAL_ERRORS Example 2
Categories SQL