by Can anyone tell me why this batch (6.5 sp5a):
use pubs
set nocount on
select 'This is a single select statement before the showcontig'
dbcc SHOWCONTIG (16003088)WITH NO_INFOMSGS
select 'after'
Produces this output:
-------------------------------------------------------
This is a single select statement before the showcontig
DBCC SHOWCONTIG scanning 'authors' table...
-------------------------------------------------------
This is a single select statement before the showcontig
[SHOW_CONTIG - SCAN ANALYSIS]
---------------------------------------------------------------------------
Table: 'authors' (16003088) Indid: 1 dbid:4
TABLE level scan performed.
- Pages Scanned................................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [0:1]
- Avg. Bytes free per page.....................: 89.0
- Avg. Page density (full).....................: 95.58%
- Overflow Pages...............................: 0
- Disconnected Overflow Pages..................: 0
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
-----
after
?
Specifically, why is the output line "This is a single select statement
before the showcontig
" repeated?
Thanks,
-b