Execute SQL Script on all subscribers
Posted in Databases, Techs/Computers on Jan 15th, 2008
At my work, we have MSSQL with replication. The problem is we have 5 SQL subscribers. Our R&D department keep coming out with Store Procedures. In order to deploy these new store procedures to production, we need to run the script on every servers. This is not only time consuming, but bounded to human error.
In […]