>I just checked the Server Manager and there were no connections to the Server running SQL Server, so I rebooted it. When I restarted SQL PerfMon, there were 6 user connections. Do SQL Server and the PerfMon use that many by themselves?
>TIA
There are a couple of way to do what you want. The first would be to use the Current Activity window in the Server Enterprise Manager. The other way is probably my favorite: from the iSQL/W tool issue the command EXECUTE sp_who.
what your going to find is that SQL Server uses some connections internally. They'll be listed starting with 1. You'll probably be using connection 10. To very this, check the @@SPID variable with a query like SELECT @@SPID.
Your original message said that you were eating connections. More that likely, you're not releasing the connection once it's been made. To verify this, run you application like normal, check the number of connections in use using sp_who, and then exit your app. You should see SQL Server reclaim the connections.
-Mike