Hi Jon,
Thanks for attention to my thread. It occurs when I save the SP to remote
sql server. The message has told us the cause,my conserns is how to solve the problem,as i don't know which tables involved. Or if the SQL SERVER was installed with different collation,how can i correct the collation,reinstall?
Your further help,thanks.

>When does the error occur? Is it when you save or run the SP?

>It sounds like your comparing data that is in a different collation format?


>Hi,
> When I update some stored procedures,no matter in MMC or SA, a error message "Error 466:Cannot resolve collation conflict for equal to operation." always raised. Any ideas? Thanks in adv.