collation change of all objects once in a db

• jamessdba

  SSCrazy

  Points: 2254

  More actions

  May 2, 2011 at 5:40 am

  #150218

  Hi,

  My Db is in : SQL_Latin1_General_CP1_CI_AS collation but still

  I am getting error in xyz db

  error serverEror Parameters supplied at run time are :1.Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation.

  How to change the collation of all the existing objects at once inside a database

  Please suggest to fix this issue

• Pam Brisjar

  SSChampion

  Points: 12094

  More actions

  May 2, 2011 at 8:45 am

  #1318443

  What is the column's collation (can be different from the database)?

  What is the server-level collation?

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  May 2, 2011 at 8:54 am

  #1318449

  That happens to me a lot when using temp tables.

  I use COLLATE DATABASE_DEFAULT to get out of the error and use the same collation for the tempdb object as the db I'm working in.