Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Push a stored proc out to multiple machines

Author  Topic 

dwjongbloed
Starting Member

9 Posts

Posted - 2013-10-08 : 18:42:21
I have an interesting task that I need help with.

I have over 100 machines that are running SQL Express and I need to update a SP on them. Does anyone know of a way to script this out to where I don't have to touch each machine?

Thanks in advance for your help.

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-10-08 : 19:49:47
Use Powershell. There are examples here https://www.simple-talk.com/sql/database-administration/why-this-sql-server-dba-is-learning-powershell/
Go to Top of Page
   

- Advertisement -