SET NOCOUNT ON madness

How do i find a stored procedure or trigger that DOESN'T have SET
NOCOUNT ON in it somewhere?
Ben

Re: SET NOCOUNT ON madness

http://vyaskn.tripod.com/sql_server_search_stored_procedure_ code.htm

using the sp_search_code procedure available from the above url,
you can find the objects that have NOCOUNT ON on them.
And doing a LEFT Join with the results, you can find the objets
that doesnt have NOCOUNT ON

--
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com


"ben h" wrote in message
news:41bfe3c9$0$21868$61ce578d@news.syd.swiftdsl.com.au...
> How do i find a stored procedure or trigger that DOESN'T have SET NOCOUNT
> ON in it somewhere?
> Ben