ALVIN R GARCIA
SSC Enthusiast
Points: 175
More actions
April 23, 2004 at 2:38 pm
#85192
The feature to detach and attach the database is gray out (not available). How can you perform this task if these features are not available to use in SQL Server enterprise Manager
April 26, 2004 at 8:00 am
This was removed by the editor as SPAM
SQLBill
SSC Guru
Points: 51440
April 26, 2004 at 8:30 am
#504235
In Query Analyzer you could run:
sp_detach_db and sp_attach_db. Refer to the BOL for more information.
Also, do you have the appropriate privileges to detach/attach a database?
-SQLBill
April 26, 2004 at 8:32 am
#504236
Forgot one thing....is this a replicated database? If so, BOL says it must be unpublished for sp_detach_db to work.
As for privileges, you must be a member of sysadmin on the database.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply