This recipe executes a predefined SQL query to multiple SQL Server instances specified in a text file.
In this recipe, we will connect to multiple SQL Server instances and execute a SQL command against all of them.
Identify the available instances for you to run your query on. Once you have identified all the instances you want to execute the command to, create a text file in C:\Temp called sqlinstances.txt and put each instance name per line in that file. For example:
localhost localhost\SQL01
Let's list the steps required to complete the task:
Open PowerShell ISE as administrator.
Import the SQLPS module:
#import SQL Server module Import-Module SQLPS -DisableNameChecking
Add the following script and run:
#replace this with your own file that contains #a list of instances you want to send the query to $instances = Get-Content "C:\Temp\sqlinstances.txt" $query = "SELECT @@SERVERNAME 'SERVERNAME', @@VERSION 'VERSION'" $databasename...