Transfering DB from one collation in SQL 2000 to a
different collation in SQL 2000.

We need to transfer our user databases from codepage 850
to 1252.

We have succesfully transfered all objects and data EXCEPT
stored procedures using the "Import/Export Data Wizard."
We then scripted all the stored procedures from the cp850
database and installed them into the cp1252. However for
quite a few stored procedures we get the error "Cannot
resolve collation conflict for equal to operation." I
have tried scripting the sp's with the option 'Only script
7.0 compatible features' on and off but get the same
errors each time.

Please you help.

Thanks

Paula.