Am o aplicatie distribuita la 10 puncte de lucru.
Am modificat 10 proceduri stocate, am sters 5 si am modificat 5, pe serverul unde dezvolt aplicatia.

Vrea sa fac actualizarile automat pt a evita erorile. Cum se face de obicei ? Un script ?
Un link eventual.

SQL Multi Script by Red Gate:
http://www.red-gate.com/products/dba/sql-multi-script/

Local Server Groups:
http://www.mssqltips.com/sqlservertip/2086/run-sql-commands-against-multiple-sql-servers-without-cms/

Central Management Servers:
http://www.mssqltips.com/sqlservertip/1767/execute-sql-server-query-on-multiple-servers-at-the-same-time/

sp_MSforeachdb:
http://www.mssqltips.com/sqlservertip/1414/run-same-command-on-all-sql-server-databases-without-cursors/

SQLCMD mode:
http://www.mssqltips.com/sqlservertip/2311/using-the-ssms-query-editor-in-sqlcmd-mode/

Powershell - scurt filmuletz (~15 min) care merita downlodat si urmarit:
http://midnightdba.itbookworm.com/VidPages/PowershellReplaceMSForEachDB/PowershellReplaceMSForEachDB.aspx