Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Default Language Setting of Database Expand / Collapse
Author
Message
Posted Friday, September 07, 2012 3:54 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, November 26, 2012 5:17 AM
Points: 134, Visits: 161
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..

Post #1355872
Posted Monday, September 10, 2012 12:36 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, November 26, 2012 5:17 AM
Points: 134, Visits: 161
83 views , but no replies....
Post #1356570
Posted Monday, September 10, 2012 1:05 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, April 06, 2014 6:06 PM
Points: 286, Visits: 570
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?
Post #1356575
Posted Monday, September 10, 2012 10:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, November 26, 2012 5:17 AM
Points: 134, Visits: 161
Thanks, so is there a log somewhere stored of when the Server settings was changed.
Post #1356870
Posted Monday, September 10, 2012 11:30 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 17, 2013 3:27 PM
Points: 481, 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.
Post #1356914
Posted Monday, September 10, 2012 9:42 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, April 06, 2014 6:06 PM
Points: 286, Visits: 570
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?
Post #1357122
Posted Wednesday, September 12, 2012 12:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, November 26, 2012 5:17 AM
Points: 134, Visits: 161
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.
Post #1357806
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse