Collation And DB2 Linked Server

• Nilssond

  Hall of Fame

  Points: 3285

  More actions

  April 5, 2004 at 6:04 pm

  #179165

  I read in a topic recently that linked server collation is important for performance when querying data. We have a linked DB2 server running on AS400.  Where can I find if there are any differences between the DB2 collation order and our SQL Server 7.0 collation order?

   

• April 8, 2004 at 8:00 am

  This was removed by the editor as SPAM

• wz700

  SSCertifiable

  Points: 7133

  More actions

  April 8, 2004 at 8:13 am

  #502154

  Get sql collation info from

  exec sp_helpsort

  Not sure about db2 link, it may relate to OLEDB provider.