select SERVERPROPERTY (''collation'') for each server on the network

• Bikeman

  Ten Centuries

  Points: 1207

  More actions

  July 13, 2005 at 4:00 pm

  #76374

  Hi,

   

  Is there an easy way to loop through all your sql servers to see what collations they are?

  I don't want to link many servers to my local sql box, and I don't see how to run sp_helpsort or select SERVERPROPERTY ('collation') with OPENQUERY...

   

  Thanks

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  July 13, 2005 at 4:07 pm

  #574182

  Check out SQLDMO (VB). It may be your next best friend.