Post reply

I need an SQL string to return the Collation of a database

  • February 21, 2008 at 6:12 am

    #184225

    I have a program in vb6 that creates a new database. I need to set the new database collation to match the original. I have the sql string to set the collation during the creation.

    What I need is a SQL string that will return the Collation property of the original database.

    😎

    I would appreciate any help

  • February 21, 2008 at 6:32 am

    #780624

    Try:-

    SELECT convert(sysname,DatabasePropertyEx('database name','Collation'))

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • February 21, 2008 at 6:57 am

    #780638

    Thanks for the help. It works.

Viewing 3 posts - 1 through 2 (of 2 total)

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