How to Rename a Database

back

sp_dboption 'oldname', 'single user', 'TRUE'
go
sp_renamedb 'oldname', 'newname'
go
sp_dboption 'newname', 'single user', 'FALSE'
go
Backback