SQL Server 2k: Know if collation sensitive or not

Question

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 739545 More actions · Answer 1

This is the reason you DO NOT go into the system tables. They change from version to version.

Better to use the sp_helpsort and parse the string. It will work on all versions.

Steve Jones