Post reply

Unable to change the collation of the Database

  • October 29, 2010 at 12:43 pm

    #388128

    HI all,

    Could anyone help to me to get the resolution for the below error.

    Msg 5075, Level 16, State 1, Line 1

    The object 'StringToStrTable' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.

    I am running the belwo command to change the collation of the DB,

    ALTER DATABASE test COLLATE SQL_Latin1_General_CP850_CI_AS

    Thanks,

    Ganesh

  • October 29, 2010 at 1:07 pm

    #1244393

    Have you had a chance to look through the site much - you may find this thread helpful.

    http://www.sqlservercentral.com/Forums/Topic442391-146-1.aspx

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • October 29, 2010 at 1:13 pm

    #1244395

    Hi Chris,

    Many thanks for help..

    I will look into the links..

    Cheers,

    Ganesh

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

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