Post reply

Default Language Setting of Database

  • September 7, 2012 at 3:54 am

    #261583

    Hi All,

    Our default language setting for a DB is set to US-english , but our client insists now that it was British and needs it to change it.

    Now I have few queries on this:

    > Can we find if the language was changed anytime earlier , i.e. is there a log maintained of when the language was last changed and by who etc..

    > Also , what kind of impact will it have (like date format will be changed) so will this insert the dates in new fomats and if we try to convert a exisiting date will it have any impact..

  • September 10, 2012 at 12:36 am

    #1535546

    83 views , but no replies....

  • September 10, 2012 at 1:05 am

    #1535550

    GonnaCatchIT (9/7/2012)

    Hi All,

    Our default language setting for a DB is set to US-english , but our client insists now that it was British and needs it to change it.

    Now I have few queries on this:

    > Can we find if the language was changed anytime earlier , i.e. is there a log maintained of when the language was last changed and by who etc..

    > Also , what kind of impact will it have (like date format will be changed) so will this insert the dates in new fomats and if we try to convert a exisiting date will it have any impact..

    Language is set at server level, at login level or at session level but not at database level.

  • September 10, 2012 at 10:13 am

    #1535805

    Thanks, so is there a log somewhere stored of when the Server settings was changed.

  • September 10, 2012 at 11:30 am

    #1535844

    One of the standard SSMS reports is "Configuration Changes History". Running this report will give you a list of updates to your SQL Server configuration over time.

  • September 10, 2012 at 9:42 pm

    #1535999

    GonnaCatchIT (9/7/2012)

    Hi All,

    Our default language setting for a DB is set to US-english , but our client insists now that it was British and needs it to change it.

    Are you sure that someone hasn't simply changed the language setting for the login that the user/application uses?

    If you want to provide more details of what has happened it may be easier to help you resolve the issue.

  • September 12, 2012 at 12:55 am

    #1536573

    Client says , the language setting has bee changed , as per us it has not , so need some kind of proof that it has not been changed.

    Bret,

    Thanks , your post was helpful.

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

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