How to Avoid DBCC o/p Message…!!! | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to Avoid DBCC o/p Message…!!!

Hi
When I executed "DBCC DBREINDEX (‘pubs.dbo.item’,Itemno, 80)" I am getting the following message….
"DBCC execution completed. If DBCC printed error messages, contact your system administrator." How can I stop this Message? Please Help
raj
Syntax
DBCC DBREINDEX
( ‘database.owner.table_name’
[ , index_name
[ , fillfactor ]
]
) [ WITH NO_INFOMSGS ] WITH NO_INFOMSGS Suppresses all informational messages (with severity levels from 0 through 10). Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
]]>