exec master..xp_cmdshell 'net pause mssqlserver'declare @n int
declare @sql varchar(100)while 1=1
begin
set @n = 0select top 1 @n = spid
from master..sysprocesses
where spid > 50 and spid <> @@spid and spid > @n
order by spidif @n = 0
breakset @sql = 'kill '+cast(@n as varchar(10))
exec(@sql)
end--你的修改语句exec master..xp_cmdshell 'net continue mssqlserver'
---------------------------------------------------------------
exec master..xp_cmdshell 'net pause mssqlserver'
---------------------------------------------------------------
declare @sql varchar(100)while 1=1
beginselect top 1 @sql = 'kill '+cast(spid as varchar(3))
from master..sysprocesses
where spid > 50 and spid <> @@spid if @@rowcount = 0
breakexec(@sql)
end
-----------------------------------------------------------------你的修改语句---------------------------------------------------------------
exec master..xp_cmdshell 'net continue mssqlserver'
---------------------------------------------------------------
sp_dboption '<db_name>', 'single user', 'true'
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionCheckForData (CheckforData()).
服务器: 消息 11,级别 16,状态 1,行 0
一般性网络错误。请检查网络文档。
连接中断请问各位大侠,有什么办法解决这个问题,在线急等...