Different database & server collation

290 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Db23
    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?
    290 pointsBadges:
    report
  • Denny Cherry
    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.
    66,065 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following