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 (286082)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
- Microsoft SQL Server 7.0
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 "sp_attach_db (T-SQL)" and "sp_detach_db (T-SQL)" topics in SQL Server 7.0 Books Online.
| Modification Type: | Major | Last Reviewed: | 11/17/2004 |
|---|
| Keywords: | kbprb KB286082 |
|---|
|