Home >Database >Mysql Tutorial >sqlserver下Kill 所有连接到某一数据库的连接
sqlserver下Kill 所有连接到某一数据库的连接
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-07 18:00:261449browse
可以通过下面代码Kill所有连接到某一数据库的所有连接
代码如下:USE master
DECLARE @spid int
DECLARE CUR CURSOR
FOR SELECT spid FROM sysprocesses WHERE dbid = 5
FETCH NEXT FROM CUR INTO @spid
WHILE @@FETCH_STATUS = 0
BEGIN
--EXEC ('KILL ' + @spid )
FETCH NEXT FROM CUR INTO @spid
END
CLOSE CUR
DEALLOCATE CUR
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：win2003 安装 sqlserver 2005的方法Next article：sqlserver 数据库被注入解决方案