Below Script provides the connections details for a particular Database in SQL Server. select spid,loginame,blocked,waittype,cpu,hostname,DB_NAME(dbid) AS DB_NAME ,status from sys.sysprocesses
Continue readingBelow Script provides the connections details for a particular Database in SQL Server. select spid,loginame,blocked,waittype,cpu,hostname,DB_NAME(dbid) AS DB_NAME ,status from sys.sysprocesses
Continue reading