Article ID: 293329 - View products that this article applies to.
This article was previously published under Q293329
BUG #: 236633 (SHILOH_bugs)
When you use SQL Server Enterprise Manager to attach multiple database files, which are saved on different hard disk driver folders, the following problems may occur:
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
You can run the sp_attach_db stored procedure to attach the database for which some of the log or data files were stored in a different directory than the primary database file.
You can run the sp_attach_single_file_db stored procedure to attach a single data file.
Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.
After You Apply SQL Server 2000 Service Pack 1
Article ID: 293329 - Last Review: November 6, 2003 - Revision: 3.2
Contact us for more help