Strange behavior with DBCC SHOWCONTIG

[kaffenils]

I am experiencing som strange behavior with DBCC SHOWCONTIG. The problem is that it displays different values for LogicalFragmentation for the same table if I run the command on just the one table or for all tables.

I have executed the commands on the Northwind database in this example so that you can (jopefully) reproduce the result.

dbcc showcontig with tableresults
dbcc showcontig ('Customers') with tableresults
dbcc showcontig ('Employees') with tableresults

The result for Customer and Employees tables are different if specify the table or run the command without a table name parameter. This is the result:



As you can see the Customers LogicalFragmentation is 33% in the first resultset and 0% in the second. The same strange result goes for Emplyees, with 0% and 100%.

Am I missing something, or is this a bug?

I'm running SQL2000 SP3 by the way.