-- 查询本机连接到该数据库实例的连接数 SELECT a.spid FROM master..sysprocesses AS a INNER JOIN master..SYSDATABASES AS b ON a.dbid = b.dbid INNER JOIN sys.dm_exec_connections AS c ON a.spid = c.session_id WHERE b.name ='DbName' AND c.client_net_address = (SELECT TOP 1 client_net_address FROM sys.dm_exec_connections WHERE Session_id = @@SPID) -- 排除部分进程 AND NOT a.program_name LIKE 'Microsoft%' --查询连接到该实例的所有客户端 SELECT DISTINCT client_net_address FROM sys.dm_exec_connections WHERE local_net_address='192.168.0.1'