Hello. A client is moving a critical database from a German system to a US English system this weekend. Are there any known issues or anything we need to look out for? E.g. in terms of umlauts and accents etc

---
frmsrcurl: http://compgroups.net/comp.databases.ms-sqlserver/

theintrepidfox (user (AT) compgroups (DOT) net/) writes:
It is unclear what "German system" and "US English system" means here.

If you are referring to the system locale of windows, there should be
issues.

If you are moving the database from a server instance with one collation
to another, there might, if the queries were not written initially to
run a different collations in server and database.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Erland Sommarskog (esquel (AT) sommarskog (DOT) se) writes:
I also occurs to me that if you create the logins from scratch there
may be issues with dateformats.

But it is a little difficult to answer such an open-ended question.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx