March 6, 2009 at 3:54 am
Hi,
I have a problem concerning the version of MS SQL Server 2005.
We are using the english version.
We are also using a software that requires MS SQL 2005 German version.
My IT freaks are telling me that it is sufficient to set the User Languange to "German" and that this would have exactly the same effect as using the original german version of MS SQL 2005.
Can you confirm that?
Thank you in advance,
Stephan
March 6, 2009 at 7:44 am
It is not quite that simple but you could use Unicode and use German code page for the German databases. I have covered some info in the thread below read it and post again if you still need help.
http://www.sqlservercentral.com/Forums/Topic655592-149-1.aspx#bm655808
Kind regards,
Gift Peddie
March 6, 2009 at 9:13 am
Hello Stephan
One of the main problems may become your tempdb.
If you install a SQL Server the tempdb gets the specified collation of the server. If you add any databases by detach or restore they (and all its tables) will hold their collation.
Problem with tempdb:
If you use any scripts/function/procedures which work with temporary tables and VARCHAR/NVARCHAR fields you may not be able to JOIN this tables with the tables of your database. The only way might be to specify the collation for each text column of each temp table used in your database.
I saw this only once in my life and the Developer still start crying if you remind them on this project 😉 .
Greets
Flo
March 9, 2009 at 9:06 am
I was already afraid that it's not the same...
Thanx for your answers!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply