Very Computer

SP_Who

and filter on the login name

Thanks

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

Quote:> Does anyone know how I can find out or log how many actual
> users are logged on to my SQL server. I keep running out of
> licenses from time to time, but in reality we should have
> enough licenses and I being wondering if SQL is duplcating
> license connections and if so how can I find this out?

> Can some tell me if there is a tool or procedure I can use?