COLLATION issue

• kapil_kk

  SSC-Insane

  Points: 21316

  More actions

  June 20, 2013 at 11:53 pm

  #279499

  Hi all,

  I have created a database on server1 with default collation, now I want to restore that database on another server server2 which has different collation due to this I am getting collation error in my scripts.

  Is there any solution for this?

  _______________________________________________________________
  To get quick answer follow this link:
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

• Arul prakash

  Old Hand

  Points: 318

  More actions

  June 21, 2013 at 12:16 am

  #1626212

  Just refer this link

  http://support.microsoft.com/kb/325335....

• Andrew G

  SSChampion

  Points: 12809

  More actions

  June 21, 2013 at 12:20 am

  #1626214

  Add COLLATE_DATABASE_DEFAULT on all your joins and where clauses..

  or change the database collation, its all here: http://www.sqlserverclub.com/articles/understanding-sql-server-collation-sequences.aspx