Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 How do I suppress "(1 row(s) affected)" messages

Author  Topic 

Jacmac
Starting Member

11 Posts

Posted - 2005-04-26 : 17:13:15
I think I read that there is a way to suppress these messages within stored procedures, but I can't remember how.

AndyB13
Aged Yak Warrior

583 Posts

Posted - 2005-04-26 : 17:18:41
SET NOCOUNT ON
SELECT .........
SET NOCOUNT OFF

Andy


Beauty is in the eyes of the beerholder
Go to Top of Page

Jacmac
Starting Member

11 Posts

Posted - 2005-04-26 : 17:19:07
Thanks
Go to Top of Page
   

- Advertisement -