How can I know No of Connection With My, SQL server!!

Hey Friends !!

How can know the number of connection with our DataBase server !!

Hope it is easy ,

But still i don't know !

Do you mean the current connections to the SQL Server database ?

Then you have a look on either the procedure sp_who / sp_who2 or the system table / view

sysprocesses

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Use the windows counters:

General Statistics --> User Connections

Ref: http://msdn2.microsoft.com/en-us/library/ms190697.aspx

|||

HI,

you may run sp_who 'Active' which will display all active connections or you may query master..sysprocesses system table also, for more detailed information refer sp_who3 from http://vyaskn.tripod.com/sp_who3.htm

Hemantgiri S. Goswami