Collation setting for all user databases

• JC0509

  Newbie

  Points: 2

  More actions

  September 22, 2009 at 3:49 pm

  #99876

  script that will show me the collation setting for all databases. This info seems to be hidden in sql server 2000.

• arun.sas

  SSChampion

  Points: 11831

  More actions

  September 22, 2009 at 9:48 pm

  #1057270

  Single DB

  select databasepropertyex('MY_DB', N'collation')

  All DB

  EXEC sp_msForEachDB ' select databasepropertyex(''?'', N''collation'') '

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  September 24, 2009 at 10:39 am

  #1058148

  Hidden ???

  sp_helpdb

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."