Strange behavior with DBCC SHOWCONTIG

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.

Code:

---

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:

http://vbforums.com/attachment.php?a...id=37186&stc=1

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.