SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
This topic has not yet been rated - Rate this topic

@@PACKET_ERRORS (Transact-SQL)

SQL Server 2008 R2

Returns the number of network packet errors that have occurred on SQL Server connections since SQL Server was last started.

Topic link icon Transact-SQL Syntax Conventions

Copy 

@@PACKET_ERRORS

To display a report containing several SQL Server statistics, including packet errors, run sp_monitor.

The following example shows using @@PACKET_ERRORS.

Copy 
SELECT @@PACKET_ERRORS AS 'Packet Errors'

Here is a sample result set.

Copy 
Packet Errors
-------------
0
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.