Post reply

Checking collation

  • April 21, 2006 at 4:40 am

    #113002

    A fairly basic question I know, but I'm not really an administrator.

     

    What is the command (in Query Analyzer, I assume) to check the collation of a SQL database?

     

    Thanks.

  • April 21, 2006 at 4:51 am

    #633455

    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

  • April 21, 2006 at 8:58 am

    #633537

    Thanks Paul

    That gave me the info I needed.

     

    Steve

  • April 21, 2006 at 12:56 pm

    #633601

    Steve,

    Try:

    SELECT DATABASEPROPERTYEX('DATABASE_NAME_GOES_HERE', 'Collation')

    Hopefully this helps.

    Dave

  • April 24, 2006 at 3:19 am

    #633717

    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.

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

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