>There are some tools out there to help you with that task. I really like http://www.red-gate.com/products/SQL_Compare/index.htm. I just can't live without it.
>

Thanks a lot, Eric. I got some other recommendations in my previous threads, but haven't yet time to get those tools and test them.

For my current task I just compared two scripts visually (printed them).

BTW, why one script shows me COLLATE and another (that I generated) was without it?

Thanks again.