SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

2
kudos

Kudos

SQL Server collation conflict: Msg 468, Level 16, State 9, Line 3 Cannot resolve the collation conflict between 'x' and "x" in the equal to operation.

published 515 days, 9 hours, 4 minutes ago posted by

sa 524 days, 10 hours, 49 minutes ago

SQL Server collation conflict: Msg 468, Level 16, State 9, Line 3 Cannot resolve the collation conflict between 'x' and "x" in the equal to operation.

The error message on subject line is familiar in a distributed environment that results into collation conflict. I had no exception due to the nature of work I handle on day-to-day and within individual clients. The distributed environment means it can be in same location having the dependancy for the application to use a multi-lingual application or servers located in different geographical locations, then collation will give a kick in the process with conflict issues. Also for the previous versions...(read more)

category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code

tags: behaviour changes, Best Practices, Collation, configuration, conflict, SQL Server, TSQL, unicode, Version

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

SQL Server collation conflict: Msg 468, Level 16, State 9, Line 3 Cannot resolve the collation conflict between 'x' and "x" in the equal to operation.

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up