Find the active SQL connection and kill it!
- 大家讲道理Original
- 2016-11-10 11:39:02865browse
select
db_name(dbid) as [Database Name],
count(dbid) as [No Of Connections],
loginame as [Login Name]
from
sys.sysprocesses
where
dbid > 0
group by
dbid, loginameStatement：
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：SQL method to implement crosstabNext article：SQL method to implement crosstab