Does anyone know how to:
When i execute a quesry, ex DBCC SHOWCONTIG, how do i edit
out the DBCC execution completed. If DBCC printed error
messages, contact your system administrator part? I am
running a cursor and i keep getting this answer back..If you don't want that line to show up, you can use the
with NO_INFOMSGS option. For instance:
DBCC SHOWCONTIG('authors') with NO_INFOMSGS
This option doesn't seem to be documented in the BOL for
DBCC SHOWCONTIG. But it works with SQL2000 SP3. I didn't
check any other version.
Linchi
>--Original Message--
>Does anyone know how to:
>When i execute a quesry, ex DBCC SHOWCONTIG, how do i
edit
>out the DBCC execution completed. If DBCC printed error
>messages, contact your system administrator part? I am
>running a cursor and i keep getting this answer back..
>.
>
No comments:
Post a Comment