Article ID: 290916 - View products that this article applies to.
This article was previously published under Q290916
BUG #: 235019 (SHILOH_bugs)
If a database consists of four or more files (any combination of data and log), the output of the following query may skip one of the files:
To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/290211/EN-US/ )INF: How to Obtain the Latest SQL Server 2000 Service Pack
Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.
To reproduce the problem, execute the following code: