The end of collation woes in SQL Serverhttp://msmvps.com/blogs/robfarley/archive/2008/01/31/the-end-of-collation-woes-in-sql-server.aspxCollation is a wonderful thing. It&#39;s what makes sure that Greek people can see their data in a Greek order, and Germans can see theirs in a German order. It helps us determine whether data should be case sensitive, or whether those little dots andenCommunityServer 2008.5 SP2 (Build: 40407.4157)re: The end of collation woes in SQL Serverhttp://msmvps.com/blogs/robfarley/archive/2008/01/31/the-end-of-collation-woes-in-sql-server.aspx#1639001Tue, 01 Jul 2008 14:17:38 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1639001tim gapinski<p>i am in the middle of hell with one of these errors. I guess I have to rebuild the master database which is actually hosted by a provider and the databases where created by someone we hired that does not speak english. &nbsp;I am being blamed for this, but I cannot understand how the collation got changed in the first place. &nbsp;I searched the hundreds of sprocs and there is no colate commands. &nbsp;I did connect with visual studio but that should not make a difference. &nbsp;Whatever happened in our scenario this situation without question should at minimum throw a warning. &nbsp;</p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1639001" width="1" height="1">re: The end of collation woes in SQL Serverhttp://msmvps.com/blogs/robfarley/archive/2008/01/31/the-end-of-collation-woes-in-sql-server.aspx#1518586Tue, 19 Feb 2008 02:27:12 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1518586bruli<p>I encountered such issue several times. it is realy frustrating. Once when one of our customers ran some scripts to update their DB system, a script always failed. I was sure that all scripts have been tested on our server and they worked properly. the error message was definitely as same as the one mentioned above.</p> <p>hopefully it will be solved in any manner.</p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1518586" width="1" height="1">A great idea for solving annoying collation issueshttp://msmvps.com/blogs/robfarley/archive/2008/01/31/the-end-of-collation-woes-in-sql-server.aspx#1497182Tue, 05 Feb 2008 12:53:44 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1497182Transaction blog<p>Rob Farley recently blogged about an excellent idea for solving the annoying collation issues so many...</p> <img src="http://msmvps.com/aggbug.aspx?PostID=1497182" width="1" height="1">