Error 13

I got an error 13 "Cannot resolve collation conflict for
equal to operation"
when trying to run some tasksThat means, you are trying to compare two character columns in your query,
but those columns are of different collations and hence the error.
Unless there's a good reason, all columns in the database should be of the
same collation. If you do need to have a different collation, then you need
to take care of that situation using the COLLATE keyword, in your queries.
if you run sp_help on the tables in question, you will see what collations
are being used by the table columns.
Look up SQL Server Books Online for more informaiton on collations and
COLLATE.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"krasi" <krkrastev@.tbicredit.bg> wrote in message
news:01f901c3de73$64587570$a001280a@.phx.gbl...
I got an error 13 "Cannot resolve collation conflict for
equal to operation"
when trying to run some tasks