Query on sql collation 2005
-
Tuesday, October 09, 2012 7:53 AM
Hi Team,
I have inherited few sql servers 2005 having Finnish collation. Now the sql jobs that I see in job monitor are in finnish language. Is there a way to change them into English language so that I can maintain them? The jobs seems to be sql maint jobs (Full backup, reindex etc) but to check each and every job using Google translater is bit crumbersome. Any help on it i appreciated.
Thanks in advance
Sameer Kapur
All Replies
-
Tuesday, October 09, 2012 7:56 AMAnswererRe-install the instance is the probably best one.
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
MS SQL Consultants: Improves MS SQL Database Performance
-
Tuesday, October 09, 2012 4:31 PM
Re-install the instance is the probably best one.
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
MS SQL Consultants: Improves MS SQL Database Performance
Thanks for the reply Uri,
Yes, that's the last option I have, but there might be issues since server is in Finland, users also are in Finland but SQl is being maintained in India, so quite a less chance that users/Mgmt might agree for a re-install just for maint. purposes. Any other options that I can try before re-install??
-
Tuesday, October 09, 2012 4:37 PM Reinstall is the easiest option if that is not possible take the challenge and try the approach suggested here
- Proposed As Answer by Allen Li - MSFTModerator Monday, October 15, 2012 1:49 AM
- Marked As Answer by Allen Li - MSFTModerator Tuesday, October 16, 2012 1:02 AM
.png)
