SQL Server修改数据库名称的常用方法

select spid from master.dbo.sysprocesses where dbid=db_id('test1');

kill spid

use master
-- 设置单用户
exec sp_dboption  @dbname='olddbname', @optname= 'single user',@optvalue= 'true'
-- 恢复多用户
exec sp_dboption  @dbname='newdbname', @optname= 'single user', @optvalue='false'
go

use master;
go
alter database test1 modify name = test;
go

alter database db名 set single_user with rollback immediate;
alter database 旧db名 modify name = 新db名;
alter database db名 set multi_user;

use master
go
exec sp_renamedb @dbname='test_1', @newname='test';
go

use master
exec sp_dboption  @dbname='olddbname', @optname= 'single user',@optvalue= 'true'
exec sp_renamedb  @dbname='olddbname', @newname= 'newdbname'
exec sp_dboption  @dbname='newdbname', @optname= 'single user', @optvalue='false'
go

select name, database_id from sys.databases where name = n'dbname';