Sounds like you have databases that have different collations from each other or from the server collations. You'll need to put a COLLATE clause in that script wherever you have a character column.
John
- This reply was modified 4 years, 9 months ago by John Mitchell-245523. Reason: or tweak the COLLATE clauses that are already there