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.