Number of open connections

[TimSki]

Hi,

We are using a remotely hosted sql serer 2005 db. We connect to it/run queries etc. using sql server management studio express.

Is there anyway to view the number of open connections using ssmse, in particular we want to see the number that are being left open ?

Thanks in advance

[deepuv04]

Hi,

We are using a remotely hosted sql serer 2005 db. We connect to it/run queries etc. using sql server management studio express.

Is there anyway to view the number of open connections using ssmse, in particular we want to see the number that are being left open ?

Thanks in advance

hi
use sp_who command to know the details

or use the query

[code=sql]

select spid,hostname,l oginame,cmd,db_ name(dbid) as dbname, status
from master.dbo.sysp rocesses
where datediff(dd,log in_time,getdate ()) = 0
order by hostname
[code]

[TimSki]

Thanks great advice however when i execute

USE Master
EXEC sp_who

it returns

0,runnable,acce ss2o_Admin,TIM-PC,0,master,SEL ECT,0

and never seems to change although i know others are connected (the site is high usage). TIM-PC is the name of my PC.

Is this because i don't have the right permissions ? btw, not sure if it's relevant but all users connect with the same connection string and username namely 'access2o_Admin '

[ck9663]

Maybe no connections are left open.

-- CK

[deepuv04]

Thanks great advice however when i execute

USE Master
EXEC sp_who

it returns

0,runnable,acce ss2o_Admin,TIM-PC,0,master,SEL ECT,0

and never seems to change although i know others are connected (the site is high usage). TIM-PC is the name of my PC.

Is this because i don't have the right permissions ? btw, not sure if it's relevant but all users connect with the same connection string and username namely 'access2o_Admin '

hi,
for more details use the following query

 
 
select spid,HostName,db_Name(dbid),Program_Name,Login_Time,Status 
from master.dbo.sysprocesses
order by hostname
 
or 
 
select * from master.dbo.sysprocesses
 

[TimSki]

thanks for all this however i did discover it was a permissions problem...

http://forums.microsof t.com/MSDN/ShowPost.aspx?P ostID=301301&Si teID=1

My provider wont grant me the permissions :( so i guess i'm stuffed unless anyone has any other suggestions ?