Post reply

Server Language & dateformat

  • February 2, 2010 at 10:02 pm

    #137807

    Hi Guys,

    how to view(via query) currently configured server language & dateformat in sqlserver 2005.

    thanks in advance.

    Cheers,

    Asan

  • February 3, 2010 at 6:21 am

    #1112801

    select * from sys.syslanguages where langid = @@langid

  • February 3, 2010 at 9:32 pm

    #1113433

    thanks COldCoffee ..

    how come we know the language .. which has been configured.?

    I got it in msdn..

    DBCC USEROPTIONS

    for the above requirements.

  • February 3, 2010 at 11:04 pm

    #1113470

    The SERVERPROERTY function can give you some info on the server level:

    For example can give you collation information to know the language info.

    Hope this helps.

    select SERVERPROPERTY ('Collation') as 'Collation'

  • February 4, 2010 at 1:57 am

    #1113535

    Asane, @@LangID gives u the language ID of the current session, which is nothing but the configured language of the server...sys.syslanguages will also retreive you the date format as well.. dbcc useroptions is also a nice find.. thanks 🙂

  • February 4, 2010 at 2:31 am

    #1113563

    I'd like to thank bdba n coldcoffe for their support 😛

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

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