Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining



Applies To: SQL Server 2014, SQL Server 2016 Preview

Returns the number of disk write errors encountered by SQL Server since SQL Server last started.

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions


Not all write errors encountered by SQL Server are accounted for by this function. Occasional non-fatal write errors are handled by the server itself and are not considered errors. To display a report containing several SQL Server statistics, including total number of errors, run sp_monitor.

This example shows the number of errors encountered by SQL Server as of the current date and time.


Here is the result set.

Errors      As of                 
----------- ----------------------
0           3/28/2003 12:32:11 PM 

Community Additions

© 2015 Microsoft