Default Language

  • Hi,

    I've run the following to change default language

    exec master.dbo.sp_configure 'default language','23'

    reconfigure with override but when I run a select @@language,@@langid I get uS_english,0

    I have also bounced the server no luck. I have recently run sp2.

    Any advice much appreciated.

    Thanks

  • This is what the 2005 BOL states:

    Use the default language option to specify the default language for all newly created logins.

    It might be working. Test a new login.

    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