SQL server 2005 Number of connections open

[Gman]

I'm using management studio 2005 is there anyway to see how many open connections there are to a particular database from my website?

Just wanting to check that I closed everything that needs closing.

Cheers

 

[voodooflux]

You might be able to get the information you want by running the sp_who system stored procedure:

exec sp_who

 

[Gman]

thanks should be able to use that seems to show them

Cheers