by Administrator | Jan 21, 2014 | Query
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...
by Administrator | Dec 13, 2013 | Query
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...