Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL 7 - Detach Option Not Shown 1

Status
Not open for further replies.

OrWolf

MIS
Joined
Mar 19, 2001
Messages
291
I'm completely baffled by this one, but have limited experience with SQL 7. Should SQL 7 provide a task to detach a database? I have what seems to be every other option, but not detach at the DB level and no attach as the database folder level. Any ideas?
 
With SQL Server 7 you have to use the sp_detach command from query analyzer. You can't detach a database from EM.

EXEC sp_detach_db 'Database_Name'
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top