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.

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

Use the GETDATE() along with Total_errors function to see the total disk errors until today.

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