Sasidhar Chowdary

• Sep 19th, 2007

 

@@connection gives no of connections

eman.alzoghby

 Profile Answers by eman.alzoghby 

• Jun 18th, 2010

 

select COUNT(*)
from master.dbo.sysprocesses p
join master.dbo.sysdatabases d on p.dbID = d.dbID
where d.name = '<name of the database>'

Phani Kiran Gullapalli

 Profile Answers by Phani Kiran Gullapalli 

• May 21st, 2011

 

Use SP_WHO2

ahmeds08

 Profile Answers by ahmeds08 

• May 30th, 2011

 

sp_who2