SQL Server Performance Forum – Threads Archive
Find collation settings
Hi, I am migrating a database from 7.00 to 2000 .Will there be any issue about collation mismatch.Please let me know how to check wht collation in 7.00 and in 2000 .I just want to know if both are same or diff. –RajivHi,<br />run in QA :<br /><br />SELECT CONVERT(char(20), SERVERPROPERTY(‘collation’))<br /><br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /><br />Regards<br /><br /><br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
Hemant, That was really helpful .Thank you. Have any documents tht better describes more about Collation and its basics.I wanna try some practicals also.
Hi,<br />its all their in BOL and you can refer Mr. Umachandars website , www.umachandar.com for more .<br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
Links:
http://database.ittoolbox.com/docum…ns-from-sql-server-70-to-sql-server-2000-2801
http://www.windowsitpro.com/SQLServer/Article/ArticleID/24504/24504.html
http://www.sql-server-performance.com/jk_sql_server_upgrade2.asp Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>