create table ConnectionCount ( [spid] bigint NOT NULL, [blocked] int NOT NULL, [dbname] varchar(250) NOT NULL, [open_tran] int NOT NULL, [status] varchar(250) NOT NULL, [hostname] varchar(250) NOT NULL, [cmd] varchar(250) NOT NULL, [login_time] varchar(250) NOT NULL, [loginame] varchar(250) NOT NULL, [net_library] varchar(250) NOT NULL ) insert into ConnectionCount select spid,blocked,d.name,open_tran,status,hostname,cmd,login_time,loginame,net_library from sys.sysprocesses p inner join sys.databases d on p.dbid=d.database_id where status not like 'background%' declare @connectioncnt float select @connectioncnt=COUNT(1) from ConnectionCount if (@connectioncnt > 500) begin declare @strsubject varchar(100) select @strsubject='Check user connection count on ' + @@SERVERNAME declare @tableHTML nvarchar(max); set @tableHTML = N'
SPID | Blocked | ' + N'DBName | Open_Tran | ' + N'Status | Hostname | ' + N'cmd | Login_Time | ' + N'Login_Name | Net_Library |
---|