SRP0005.md

SQL Server Rule: SRP0005

Assembly	SqlServer.Rules.dll
Namespace	SqlServer.Rules.Performance
Class	ConsiderAddingSetNoCountOnRule

Rule Information

Id	SRP0005
Friendly Name	Noisy trigger
Category	Performance
Ignorable	true
Applicable Types	Dml Trigger
	Procedure

Description

SET NOCOUNT ON is recommended to be enabled in stored procedures and triggers.

Summary

SET NOCOUNT ON is recommended to be enabled in stored procedures and triggers