Sp_renamedb

  • I am trying to rename a database by using sp_renamedb 'oldname', 'newname'

    It keeps me giving me error messages .

    1. The database could not be exclusively locked to perform the operation.

    Please let me know how to get around it.

    I tried changing setting to DBO use only in sp_dboption..

    thats doesnt work either..

    please help,,what to do?/

     

    Taj


    Tajammal Butt

  • You could place the db in single user mode and then execute. 

    alter db command or through enterprise manager.

  • Look at current activity. Determine who is still in the database and ask them to get out. Then proceed with the rename.

    Bph

    BPH

  • Ask for the properties of the database / Option tab / restict access / select members of DB_Owner.

    First be sure to communicate this action to the current active users.

    GKramer

     

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

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