Find SQL Stored Procedures with NOTCOUNT ON missing

 It is recommended to have SET NOCOUNT ON in all your stored procedures.

To find how many of the procedure are missing mentioned parameter, execute below.

select * from sys.syscomments

where text like '%CREATE PROCEDURE%'

and text not like '%NOCOUNT%'