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...

Query: How to change a Sql Server database collation

To change a Sql Server database collation, do the following: Connect to the Database Engine From the Standard bar, click New Query Copy and paste the following into the Query window and click Execute: ALTER DATABASE Licence SET RESTRICTED_USER; ALTER DATABASE Licence...