Connection details

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

dbo.benyos SSCommitted Points: 1944 More actions · Answer 1

Hi

You could try

EXEC sp_who2

But if you want to get the counts, try this:

select db_name(dbid),count(*) NumOfConns from master..sysprocesses group by dbid

Hope this is what you were looking for

Tal Ben Yosef

mahesh.kumar Old Hand Points: 355 More actions · Answer 2

Old Hand

Points: 355

July 4, 2008 at 7:44 am

Ya this is what am looking for. Thanks a lot

Vijaya Kadiyala SSCrazy Eights Points: 9119 More actions · Answer 3

Hi

select count(*) from master..sysprocesses where spid > 50 will give you

a rough number. This will include logins from SQL Agent. Note that the

same user can be using multiple connections from the same application,

and thus be counted more than once.

Thanks -- Vj

Thanks -- Vijaya Kadiyala
www.dotnetvj.com
SQL Server Articles For Beginers