Post reply

Pls, Help Change Collation Database Error

  • February 14, 2007 at 7:54 pm

    #176774

    I would like to change collation database

    I use this query ALTER DATABASE SAMPLE_DB COLLATE French_CI_AS

    It have error like this ka.

    Server: Msg 5030, Level 16, State 2, Line 1

    The database could not be exclusively locked to perform the operation.

    Server: Msg 5072, Level 16, State 1, Line 1

    ALTER DATABASE failed. The default collation of database 'SPdb_Dom' cannot be set to Thai_CI_AS.

  • February 14, 2007 at 9:17 pm

    #689866

    Bring the database to single user mode then fire your alter statement that should work....

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • February 15, 2007 at 6:46 pm

    #690114

    Thank you for you advise. I will try to do follow this ka.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply