Returns the number of network packet errors that have occurred on SQL Server connections since SQL Server SQL Server was last started.
Transact-SQL Syntax Conventions
@@PACKET_ERRORS
integer
To display a report containing several SQL Server statistics, including packet errors, run sp_monitor.
The following example shows using @@PACKET_ERRORS
.
SELECT @@PACKET_ERRORS AS 'Packet Errors';
Here is a sample result set.
Packet Errors
-------------
0
[@@PACK_RECEIVED (Transact-SQL)](../../t-sql/functions/pack-received-transact-sql.md)
[@@PACK_SENT (Transact-SQL)](../../t-sql/functions/pack-sent-transact-sql.md)
sp_monitor (Transact-SQL)
System Statistical Functions (Transact-SQL)