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.