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
June 21, 2013 at 12:16 am
#1626212
Just refer this link
http://support.microsoft.com/kb/325335....
Andrew G
SSChampion
Points: 12809
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply