Monitoring users

[androoo]

Hi I need to be able to monitor active connections to test that connection pooling is working effectively.
As i dont have permission to run sp_who is there another way to look at the database connections?

Thanks, A

[junior]

You can accomplish this by querying the master..sysprocesses and searching for your database name in your select statement


junior

DiscountASP.NET

www.DiscountASP.NET (http://www.DiscountASP.NET)