packet-errors-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs
@@PACKET_ERRORS (Transact-SQL)	@@PACKET_ERRORS (Transact-SQL)	VanMSFT	vanto	09/18/2017	sql	t-sql	reference	@@PACKET_ERRORS @@PACKET_ERRORS_TSQL	@@PACKET_ERRORS function number of packet errors packets [SQL Server], errors networking [SQL Server], packet errors connections [SQL Server], packets	TSQL

@@PACKET_ERRORS (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Managed Instance]

Returns the number of network packet errors that have occurred on [!INCLUDEssNoVersion] connections since [!INCLUDEssNoVersion] was last started.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

@@PACKET_ERRORS  

Return Types

integer

Remarks

To display a report containing several [!INCLUDEssNoVersion] statistics, including packet errors, run sp_monitor.

Examples

The following example shows using @@PACKET_ERRORS.

SELECT @@PACKET_ERRORS AS 'Packet Errors';  

Here is a sample result set.

Packet Errors  
-------------  
0  

See Also

@@PACK_RECEIVED (Transact-SQL)
@@PACK_SENT (Transact-SQL)
sp_monitor (Transact-SQL)
System Statistical Functions (Transact-SQL)