Query: How to see connected users

To see which users are connected to DeMaSy database, do the following:
  • Open Microsoft Sql Server Management Studio
  • Connect to the Master database and create a new query
  • Paste the following in the window: SELECT hostname, program_name FROM sys.sysprocesses WHERE dbid > 0 and DB_NAME(dbid) = 'DeMaSy' order by hostname
  • Execute the query