Collation/Sort Question

• speja01

  SSC Eights!

  Points: 984

  More actions

  July 7, 2009 at 7:25 pm

  #211835

  Hi All,

  I've been requested to move a SQL Server 2005 database from one instance to another. The two instances were created using different sort settings. Will this cause any issues with the database once it is moved over? I thought I read somewhere that this scenario will cause issues in TEMPDB. Any help would be appreciated.

  Thanks

• GURSETHI

  SSCommitted

  Points: 1912

  More actions

  July 8, 2009 at 9:15 am

  #1021772

  Hi,

  You are right there can be some problem in this configuration. Please go thru this article posted on Database Journal (with examples).

  Beware of Mixing Collation with SQL Server 2000 Part-I

  http://www.databasejournal.com/features/mssql/article.phpr/1587631/Beware-of-Mixing-Collation-with-SQL-Server-2000---Part-1.htm

  Regards

  GURSETHI