Post reply

Read glolal settings of server vs Database

  • October 23, 2010 at 1:19 pm

    #388083

    HI..

    I load my MSSQL 2005 database onto a shared hosting environment.

    My local server has default settings ( as per US MSSQL)

    For example date is : MM/DD/YYYY

    How can I run some code to read/check default settings/formats either in hosting server or my database of dates, times, numbers etc

    I guess DOM system functions would do this, but how ?

    Thanks

  • October 25, 2010 at 9:34 am

    #1241687

    Datetime settings usually default to what is set in your server / database collations. That's what you need to check.

    Not quite sure how to check it off the top of my head. I'll do some research. In the meantime, you might want to check Books Online to see if the collation is stored in catalog views.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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