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…

%d bloggers like this: