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
 SQL Server Development (2000)
 Suppressing Messages

Author  Topic 

magesh
Starting Member

23 Posts

Posted - 2005-09-01 : 02:19:25
Hi all,

i want to know how to suppress messages in sql query analyser..
i.e messages like "7 rows affected" has to be suppressed(ommited)
is there any option for doing this programmatically

regards
Magesh

ryanston
Microsoft SQL Server Product Team

89 Posts

Posted - 2005-09-01 : 02:30:54
SET NOCOUNT ON

Thanks,

----------------------
Ryan Stonecipher
Developer, Microsoft SQL Server Storage Engine, DBCC
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

magesh
Starting Member

23 Posts

Posted - 2005-09-01 : 02:42:00
thanks ryanston,,

i got it..

regards
Magesh
Go to Top of Page
   

- Advertisement -