Checking collation

Question

Viewing 5 posts - 1 through 4 (of 4 total)

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

paul_richardson SSCarpal Tunnel Points: 4594 More actions · Answer 1

hi steve,

it appears if you use sp_helpdb. However be aware on sql 2000 collation orders can be set at the database, table and column level.

hope this helps

Paul

Steve Bavis SSC Enthusiast Points: 107 More actions · Answer 2

SSC Enthusiast

Points: 107

April 21, 2006 at 8:58 am

Thanks Paul

That gave me the info I needed.

Steve

tc9d SSC Enthusiast Points: 149 More actions · Answer 3

Steve,

Try:

SELECT DATABASEPROPERTYEX('DATABASE_NAME_GOES_HERE', 'Collation')

Hopefully this helps.

Dave

Steve Bavis SSC Enthusiast Points: 107 More actions · Answer 4

Thanks Dave.

That's more concise than the sp_helpdb when all you want is the collation. I'll make a note of that one too.