Post reply

Detach a DB

  • September 17, 2004 at 3:31 am

    #181867

    Hi All,

    I am working on SQL server 2000 and I want to detach a database.

    In this particular SQL server installation I am not able to detach any database as the option to detach database does not show up in the ALL TASKS in entriprise manager.

    Please help me how can i detach a database, may be some system stored procedure or how or to get the option available in entririze manager..

    thanks

    Naveen

  • September 17, 2004 at 5:42 am

    #523477

    research BOL "detaching database from server" or sp_detach_db.

    You may also want to make sure that the "active" part of EM is at the database level of the database you wish to detach

     



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • September 17, 2004 at 8:24 am

    #523507

    What is your access (permission) level? Maybe that's the problem.

    -SQLBill

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

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