usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON
/*
Author : Brahmanand Shukla (SQLServerCarpenter.com)
Date : 27-May-2022
Purpose : To get all the stored procedures and triggers missing the use of SET NOCOUNT ON.
This procedure may be helpful in performance tuning assignments.
Example:
EXEC usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON
*/
CREATE OR...
2022-07-04