SQl 2008 change collation of all columns

  • HI,

    How can I change collation of all columns in sql 2008.

    I am getting error for keys.

    Is there any script to drop keys and change collation and then again generate the keys

    which was dropped earlier.

  • What error code are you getting?

    -Arun

  • When you first install sql you specify the collation to use as the default.

    you are able to create views and at that time specify the translated collation to use if you desire.

    Where is the message appearing from ? is it in the application or when you are writing script ?

    ________________________________________________________________________________________________
    Regards
    Steve
    SQL 2008 DBA/DBD - MCTS/MCITP

    Please don't trust me, test the solutions I give you before using them.

  • While Creating database you can specify the collation type you want.

    By default, it will be SQL SERVER DEFAULT SQL_Latin1_General_CP1_CI_AS

    If you are getting error, you can specify as column name COLLATE collation type

    Thanks

  • deepzzzz (9/3/2012)


    While Creating database you can specify the collation type you want.

    By default, it will be SQL SERVER DEFAULT SQL_Latin1_General_CP1_CI_AS

    If you are getting error, you can specify as column name COLLATE collation type

    It will be the collation of whatever the model DB is, which is not nessesarily SQL_Latin1_General_CP1_CI_AS, it will depend what collation the server was installed with or if the user has changed the collation of model.

  • mssqlsrv (9/2/2012)


    HI,

    How can I change collation of all columns in sql 2008.

    I am getting error for keys.

    Is there any script to drop keys and change collation and then again generate the keys

    which was dropped earlier.

    This topic should help

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

    Comment from Paul Smith-221741 @ 11/20/2009 9:28:51 AM

  • Thanks for the link Anthony.

    I'll try to implement the steps and will inform you all guys!

Viewing 7 posts - 1 through 6 (of 6 total)

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