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 5 years, 7 months ago by John Mitchell-245523. Reason: or tweak the COLLATE clauses that are already there