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.
Author |
Topic |
WJHamel
Aged Yak Warrior
651 Posts |
Posted - 2011-10-18 : 13:23:52
|
Is there a setting in mgmt studio which will show me only the errors in the messages window as opposed to 20,000 rows of "(1 row (s) affected)"? Scrolling through all of that to hope my peripheral vision catches the flash of red text for the errors is a bit much. |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
alexylee
Starting Member
14 Posts |
Posted - 2011-10-18 : 13:55:33
|
If you want to suppress the rows affected message for all new queries in Sql Management Studio, you can set in Tools->Options.SSMS Tools -> Options -> Query Execution -> SQL Server ->Advanced -> check SET NOCOUNT.[url]http://www.SQLMgmt.com[/url]http://www.sqlmgmt.com |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|