Cannot change collation for MSSQL DB

Discussion in 'Databases' started by MAGICIAN, Feb 11, 2010.

  1. 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 !
     
  2. Ray

    Ray

    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.
     
  3. 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.....
     
  4. Ray

    Ray

    what is the error message you are getting?
     
  5. Yes, everything works! Many thanx !
     
  6. Thank you, Ray, now my DB supports russian. Many thanx !
     

Share This Page