No, but close. This shows how many connections were open since SS was last started. I am looking for the number of currently open connections. Appreciate the effort though, thanks (yet again) Clubman.
Perhaps there's a standard (pseudo?) stored procedure for returning this info rather than a raw SQL query? It's been a while since I did SQL Server stuff in anger...
Is the section entitled "Using code to monitor performance counters" in [broken link removed] of any use? I'm not sure if this is .NET specific though...