January 24, 2006 at 12:35 pm
How can I supress messages being output in Query Analyzer?
I found this but I don't see the option to suppress messages: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_set-set_40c4.asp
January 24, 2006 at 1:13 pm
Hello Bill,
Check out "SET NOCOUNT" in BOL.
Thanks and have a nice day!!!
Lucky
January 25, 2006 at 2:43 am
In the menus, Tools, Options and go to the Connection Properties tab, you can set NOCOUNT and ANSI_WARNINGS there. But make a note of your currentsettings, it is also worth comparing them with the Database and Server properties in EM, and check out the on-line help before changing anything. Fiddling with these can lead to unexpected results from queries.
David
If it ain't broke, don't fix it...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply