SQL Server 单用户多用户模式切换

单用户改为多用户执行SQL:

USE master;
GO
declare @kid varchar(8000)
set @kid=''
select @kid=@kid+' kill '+cast(spid as varchar(8)) from master..sysprocesses where dbid=db_id('MOM_FUYAO_BAK')
Exec(@kid)
GO
ALTER DATABASE MOM_FUYAO_BAK SET MULTI_USER
GO

多用户改为单用户执行SQL：

ALTER DATABASE DBname SET SINGLE_USER

设置数据库只读状态SQL：

ALTER DATABASE DBname SET READ_ONLY