Identfying current users of database

[PeDa]

Even though I know that others are connected to the database, a script like

select DB_NAME(dbid) as 'Database', loginame as LoginName
FROM sys.sysprocesses WHERE DB_NAME(dbid) ='myDatabase'

only shows myself, and not the other users. Any suggestions?

 

[bborissov]

sp_who
sp_who2
?

Borislav Borissov
VFP9 SP2, SQL Server

 

[PeDa]

Thank you; unfortunately sp_who and sp_who2 yield the same result as my script: only me

 

[bborissov]

Than you don';t have permissions

https://social.msdn.microsoft.com/F...ons-in-a-contained-database?forum=transactsql

Borislav Borissov
VFP9 SP2, SQL Server

 

[PeDa]

Thank you. I was beginning to fear this. I shall see if the IT-department will GRANT VIEW SERVER STATE to me.