>Have multiple SQL servers that we would like to be able to update its stored procedures and functions at the same time. Wrote a VFP program to do that, it works well, but some times the stored procedures are too large and will have ODBC problems.
>
>What is the best way to update procedures and functions on multiples servers?
>We don’t want to create the wheel from scratch if there is already something out there that can help.
>Any suggestions will be greatly appreciated.

Mike,

One idea is to put all of the ALTER PROCEDURE statements into one script file, then create a DTS task that executes the script on each server.