InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 00:06:43 GMT20http://www.sqlservercentral.com/Forums/Topic9014-90-1.aspxgood article. I wonder if you could create a part two on running queries against databases with different collations using "Collate Database_Default" or other methods, tips etc.A problem I am running into is this will not work on SQL7 so I must test server version first.I have tried to avoid collation errors by clicking a check box CollationCompatible at LinkedServers/&lt;ServerName&gt;/Properties/ServerOptions but it does not seem to work.Brian LockwoodLockwoodTech Softwarehttp://www.lockwoodtech.comMon, 06 Jan 2003 10:34:00 GMTBrian Lockwoodhttp://www.sqlservercentral.com/Forums/Topic9014-90-1.aspxComments posted to this topic are about the content posted at <A HREF=http://www.sqlservercentral.com/columnists/glarsen/collate_part2_1.asp>http://www.sqlservercentral.com/columnists/glarsen/collate_part2_1.asp</A>Sun, 29 Dec 2002 00:00:00 GMTGreg Larsen