SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Default Language Setting of Database


Default Language Setting of Database

Author
Message
GonnaCatchIT
GonnaCatchIT
Old Hand
Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)

Group: General Forum Members
Points: 303 Visits: 517
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..
GonnaCatchIT
GonnaCatchIT
Old Hand
Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)

Group: General Forum Members
Points: 303 Visits: 517
83 views , but no replies....
MissTippsInOz
MissTippsInOz
SSC-Addicted
SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)

Group: General Forum Members
Points: 401 Visits: 597
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.

Clare
_________________________________________________________________________________________________________________
Measure twice; cut once (and have a good saw)

Hey, just a thought.....did you check Books Online yet?
GonnaCatchIT
GonnaCatchIT
Old Hand
Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)

Group: General Forum Members
Points: 303 Visits: 517
Thanks, so is there a log somewhere stored of when the Server settings was changed.
SQLmountain
SQLmountain
Mr or Mrs. 500
Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)

Group: General Forum Members
Points: 535 Visits: 782
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.
MissTippsInOz
MissTippsInOz
SSC-Addicted
SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)

Group: General Forum Members
Points: 401 Visits: 597
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.

Clare
_________________________________________________________________________________________________________________
Measure twice; cut once (and have a good saw)

Hey, just a thought.....did you check Books Online yet?
GonnaCatchIT
GonnaCatchIT
Old Hand
Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)

Group: General Forum Members
Points: 303 Visits: 517
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search