Sp_renamedb

• Taj

  Mr or Mrs. 500

  Points: 566

  More actions

  October 15, 2004 at 2:03 pm

  #182099

  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

• Osoba

  SSCommitted

  Points: 1964

  More actions

  October 15, 2004 at 2:35 pm

  #526955

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

  alter db command or through enterprise manager.

• Dobbs77

  SSC Eights!

  Points: 909

  More actions

  October 20, 2004 at 9:50 am

  #527330

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

  Bph

  BPH

• Guus Kramer

  Ten Centuries

  Points: 1031

  More actions

  October 22, 2004 at 1:52 am

  #527591

  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