保捱科技网

全部频道

您的当前位置：首页如何查看sqlserver数据库连接数

如何查看sqlserver数据库连接数

来源：保捱科技网


SELECT*FROM [Master].[dbo].[SYSPROCESSES]WHERE[DBID] IN ( SELECT [DBID] FROM [Master].[dbo].[SYSDATABASES] WHERE NAME=databaseName ) 无 SELECT * FROM [Master].[dbo].[SYSPROCESSES] WHERE [DBID] IN ( SELECT [DBID] FROM [Master].[dbo].[SYSDATA

SELECT * FROM
[Master].[dbo].[SYSPROCESSES] WHERE [DBID]
IN
(
SELECT
[DBID]
FROM
[Master].[dbo].[SYSDATABASES]
WHERE
NAME='databaseName'
) <无> $velocityCount--> 
SELECT * FROM 
[Master].[dbo].[SYSPROCESSES] WHERE [DBID] 
IN 
(
 SELECT 
 [DBID]
 FROM 
 [Master].[dbo].[SYSDATABASES] 
 WHERE 
 NAME='databaseName'
)
显示全文