SQL @@PACKET_ERRORS

SQL @@PACKET_ERRORS Statistical Function returns the network packet errors that occurred on connection since the last time the SQL server started. The syntax behind this @@PACKET_ERRORS is

@@PACKET_ERRORS

SQL @@PACKET_ERRORS Example

The code snippet below will show you the total number of network packet errors that occurred in this SQL Server. Learn more about SQL GETDATE from our SQL tutorial page.

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

You can use the GETDATE() along with the @@PACKET_ERRORS function to see the network errors until today. Please refer to the SQL @@PACK_SENT and SQL @@PACK_RECEIVED articles.

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