1

SELECT SPID FROM master.dbo.sysprocesses WHERE dbid=DB_ID('Test1');

1

KILL SPID

1

2

3

4

5

6

use master

-- 设置单用户

exec sp_dboption  @dbname='OldDbName', @optname= 'Single User',@optvalue= 'TRUE'

-- 恢复多用户

exec sp_dboption  @dbname='NewDbName', @optname= 'Single User', @optvalue='FALSE'

GO

1

2

3

4

USE master;

GO

ALTER DATABASE Test1 MODIFY NAME = Test;

GO

1

2

3

ALTER DATABASE db名 SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

ALTER DATABASE 旧db名 MODIFY NAME = 新db名;

ALTER DATABASE db名 SET MULTI_USER;

1

2

3

4

use master

go

exec sp_renamedb @dbname='Test_1', @newname='Test';

go

1

2

3

4

5

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

1

SELECT name, database_id FROM sys.databases WHERE name = N'DbName';