select connectnum=count(distinct net_address)-1 from master..sysprocesses SELECT COUNT(*) AS CONNECTIONS FROM master..sysprocesses SELECT cntr_value AS User_Connections FROM master..sysperfinfo as p WHERE p.object_name = 'SQLServer:General Statistics' And p.counter_name = 'User Connections' SELECT * FROM [Master].[dbo].[SYSPROCESSES] WHERE [DBID] IN ( SELECT [DBID] FROM [Master].[dbo].[SYSDATABASES] WHERE NAME='Hyundaisms')
查看SqlServer数据库连接状态
最新推荐文章于 2024-07-20 13:54:45 发布