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 |
|
heygee
Starting Member
27 Posts |
 Posted - 2005-08-12 : 05:29:50
|
| Hi all,Just wondered if there was any way to suppress information messages from SQL Server for DBCC SQLPERF(LOGSPACE) & DBCC SHOWFILESTATS. I have seen DBCC CHECKDB dbname WITH NO_INFOMSGS but can’t seem to get the same principle to work with the 2 that I am looking at.TIA,GeeGee"Happiness is a good health and a bad memory!" |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-08-12 : 11:07:41
|
| As I replied on dbforums.com, no - if NO_INFOMSGS doesn't work then there's no way to do it.Paul RandalDev Lead, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
heygee
Starting Member
27 Posts |
Posted - 2005-08-12 : 11:12:04
|
| Just as I thought, thanks for replying.Gee"Happiness is a good health and a bad memory!" |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-08-12 : 11:20:24
|
| I should have also said that NO_INFOMSGS is supported for all documented DBCC commands in SQL Server 2005 (note that SHOWFILESTATS is undocumented and unsupported)ThanksPaul RandalDev Lead, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
|
|
|
Suppress SQL Server information messages