>Is there a way to eliminate caution messages in a script? I am receiving this about 120 times because my script deals with about 120 tables:
>
>

>Caution: Changing any part of an object name could break scripts and stored procedures.
>

My immediate thought was about SET ANSI_WARNINGS (T-SQL), but checking BOL doesn't seem to be it. Anyway, try with them off and also check other references from this link.