October 15, 2004 at 2:03 pm
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
October 15, 2004 at 2:35 pm
You could place the db in single user mode and then execute.
alter db command or through enterprise manager.
October 20, 2004 at 9:50 am
Look at current activity. Determine who is still in the database and ask them to get out. Then proceed with the rename.
Bph
BPH
October 22, 2004 at 1:52 am
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