Home > IT Answers > Database > Different database & server collation
Db23
290 pts.
 Different database & server collation
Collation, SQL Server 2005
Hi, We have a database that is sitting on a SQL Server 2005 with different collation setting, the application connect to the database is running with out any issue. Have anyone had this same issue, if so how long has your application run with different database and server collation without running into collation issue? Thanks

Software/Hardware used:
ASKED: October 14, 2009  5:26 AM
UPDATED: October 19, 2009  6:32 PM
RELATED QUESTIONS
Answer Wiki:
As long as you aren't running queries that join tables between databases you can have a database in a different collation for ever. It doesn't effect the length of time the database can be hosed on that instance. You could have each user database on the server have a different collation if you wanted to.
Last Wiki Answer Submitted:  October 16, 2009  4:28 am  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thanks for clearing this up, have you had any application connecting to a production databases with different collation than the SQL Server 2005 instance? If so how common is this and how has it been running?

Db23
 290 pts.
 

Yes, a company I worked for a couple of years ago was setup like this. I’m not sure how common it is. Some applications require a specific collation for one reason or another. Overall I would say that it’s probably not that common outside of a large hosting provider.

Denny Cherry
 64,550 pts.