-- =============================================
-- Author: <lisky>
-- Create date: <2010-09-10>
-- Description: <查看连接到SQL Server数据库的用户信息>
-- =============================================
ALTER PROCEDURE [dbo].[SMC_GetDBConnectionsInfo]
@DatabaseName sysname=NULL, --参数1:要查询的数据库名称,默认查询所有数据库的连接信息
@ShowIPAddress bit=0 --参数2:是否显示IP地址,默认为否(查询IP地址比较费时,但必须启用 'xp_cmdshell' 组件)
AS
SET Transaction Isolation Level Read UNCOMMITTED
SET NOCOUNT ON <
-- Author: <lisky>
-- Create date: <2010-09-10>
-- Description: <查看连接到SQL Server数据库的用户信息>
-- =============================================
ALTER PROCEDURE [dbo].[SMC_GetDBConnectionsInfo]
@DatabaseName sysname=NULL, --参数1:要查询的数据库名称,默认查询所有数据库的连接信息
@ShowIPAddress bit=0 --参数2:是否显示IP地址,默认为否(查询IP地址比较费时,但必须启用 'xp_cmdshell' 组件)
AS
SET Transaction Isolation Level Read UNCOMMITTED
SET NOCOUNT ON <