Archive
Archive for March 14, 2013
SQL Sever – PowerShell for Executing a SQL Query on Multiple Servers
March 14, 2013
13 comments
This is 50th Article on Bi-BigData.com and we are getting great response from the community. This article will be covering how to use PowerShell and SMO to connect multiple SQL Server instances and execute a pre defined SQL command against all of them. This is applicable when we have same database available on multiple SQL Server Instances where you want to execute same SQL query. We are going to use the Invoke-Sqlcmd cmdlet to achieve our mission. Read more…
Categories: Powershell, SQL Server
powershell, powershell for, sql server