In one of my query, its giving the following error from GUI. If I execute the same query in SQL Query Analyzer the error message is the same.
Server: Msg 446, Level 16, State 9, Line 1
Cannot resolve collation conflict for equal to operation.
We have an application which supports DB2 as well as SQL Server.
The same query works fine in DB2.
Also, I dont not want to append 'collate' keyword infront of VARCHAR type columns as this will require a change in query which will not work for DB2.
Please suggest a solution which can be applied on database and not on query.
Thanks in advance