Detaching and Attaching database

  • 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

  • Alvin,

    You may not have the rights to do this but the T-SQL commands are sp_attach_db and sp_detach_db.  You can learn more about them thru BOL or support.microsoft.com or from one of the forums here

    Good Luck,



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • Alvin,

    Please don't submit multiple posts on the same question. It makes it difficult for those who might respond. I responded to your other post only to find this one and see the same answer has been given to you already.

    -SQLBill

  • SQLBILL- Sorry about that. I accidentally click post reply twice. thank you very much for your help

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply