SHOWCONTIG output "stutter"

SHOWCONTIG output "stutter"

Post by BBogar » Sat, 12 Feb 2000 04:00:00



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