Microsoft KB Archive/286082

= PRB: The Attach Database option and the Detach Database option are not available when you try to attach or detach a database on SQL Server 7.0 by using Enterprise Manager that was installed from SQL Server 2000 =

Article ID: 286082

Article Last Modified on 11/17/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q286082



SYMPTOMS
In SQL Server 7.0 and SQL Server 2000, the data and transaction log files of a database can be detached and then reattached to another server, or even to the same server. In SQL Server 2000, this can be done by using Transact-SQL commands or the SQL Server 2000 Enterprise Manager tool.

However, when you attempt to attach or detach a database on SQL Server 7.0 using Enterprise Manager installed from SQL Server 2000, the Attach Database and Detach Database options are unavailable.



WORKAROUND
This behavior is by design. To work around this problem, you can use the sp_attach_db and sp_detach_db stored procedures to attach and detach the database. For additional information, see the &quot;sp_attach_db (T-SQL)&quot; and &quot;sp_detach_db (T-SQL)&quot; topics in SQL Server 7.0 Books Online.

Keywords: kbprb KB286082

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.