You can run the query
and filter on the login name
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
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?