Hello all, I am experiencing problems when I try to execute ALTER DATABASE db_2349_vasili COLLATE cyrillic_general_ci_as I am receiving Msg 5030, Level 16, State 2, Line 2 The database could not be exclusively locked to perform the operation. Msg 5072, Level 16, State 1, Line 2 ALTER DATABASE failed. The default collation of database 'db_2349_vasili' cannot be set to Cyrillic_General_CI_AS. Can anyone help ? Thanx !
Try running this command... Alter Database [database_name] SET Single_user with rollback immediate This will make sure no one else can log into the database and lock it as you're updating the collation. Remember once you update the collation you should run the command... Alter Database [database_name] SET Multi_user on your database.
Cannot connect :-( I am sorry, I executed the command Alter Database db_2349_vasili SET Single_user with rollback immediate and now I cannot even connect to the server.....