将数据库设置为single模式: 修改数据库dbName 将single_user设置为立即回滚 尝试重命名数据库: 修改数据库dbName = NewName 设置数据库为多用户模式: ALTER DATABASE NewName 将multi_user设置为立即回滚

use master

ALTER DATABASE BOSEVIKRAM SET SINGLE_USER WITH ROLLBACK IMMEDIATE  

exec sp_renamedb 'BOSEVIKRAM','BOSEVIKRAM_Deleted'

ALTER DATABASE BOSEVIKRAM_Deleted SET MULTI_USER

您可以尝试将数据库设置为单用户模式。

https://stackoverflow.com/a/11624/2408095

use master
ALTER DATABASE BOSEVIKRAM SET SINGLE_USER WITH ROLLBACK IMMEDIATE    
ALTER DATABASE BOSEVIKRAM MODIFY NAME = [BOSEVIKRAM_Deleted]
ALTER DATABASE BOSEVIKRAM_Deleted SET MULTI_USER

SQL Server Management Studio (SSMS)中:

你也可以在对象资源管理器中右键单击你的数据库，然后转到属性。从那里，进入选项。向下滚动并将限制访问设置为SINGLE_USER。更改数据库名称，然后返回并将其设置为MULTI_USER。

这对我来说很管用:

USE [master];
GO
ALTER DATABASE [OldDataBaseName] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
GO
EXEC sp_renamedb N'OldDataBaseName', N'NewDataBaseName';


-- Add users again
ALTER DATABASE [NewDataBaseName] SET MULTI_USER
GO

首先尝试关闭数据库的所有连接:

use master
ALTER DATABASE BOSEVIKRAM SET SINGLE_USER WITH ROLLBACK IMMEDIATE 

ALTER DATABASE BOSEVIKRAM MODIFY NAME = [BOSEVIKRAM_Deleted]

ALTER DATABASE BOSEVIKRAM_Deleted SET MULTI_USER

从这里开始