For your collation, it is probably one of the settings for the scripting that adds them to one script but not to the other.
>>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.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com