Execute a Query against multiple servers

Do you have SQL Server 2008? If so you can take advantage of the Central Management Server feature which lets you register multiple servers on that server and execute one query against multiple servers from there.

BOL on how to Create a CMS:

http://msdn.microsoft.com/en-us/library/bb934126.aspx

Nice Wiki on CMS and how to use it (w/ video):

http://sqlserverpedia.com/wiki/Central_Management_Server

If you DONT have a SQL Server 2008 available in house then I suggest installing SSMS Tools pack:

http://www.ssmstoolspack.com/

This will allow that functionality along with a WHOLE lot more. A MUST have for any SQL pro and its free!

I talk for myself, but every time I think in repetition and multiple servers think about powershell. My suggestion would be:

1 - If I have only one password for all servers . Create a .Txt with the name of all servers in the c:\PS\servers.txt

server1
server2
server3\instance1
server3\instance2

foreach ($svr in get-content "C:\PS\Servers\servers.txt"  )
{
    	 trap  [Exception] {
    	 	$Err = $_.Exception.Message
    	 	Write-Host $Err  " Cannot Alter login at "  $svr
    		$Error.Clear()
    		continue;
    	   }	

    $sql = "ALTER LOGIN [sa] WITH PASSWORD='NEWPASSWORD'"
    Invoke-Sqlcmd -ServerInstance $svr -Database "MASTER" -Query $Sql -ErrorAction stop

}

2 - If I have Different passwords for each server. Put the password in front of each server, separated by commas

server1,PWD1
server2,PWD2
server3\instance1,PWD3
server3\instance2,PWD4

foreach ($svr in get-content "C:\PS\Servers\servers_pwd.txt"  )
{
    	 trap  [Exception] {
    	 	$Err = $_.Exception.Message
    	 	Write-Host $Err  " Cannot Alter login at "  $server[0]
    		$Error.Clear()
    		continue;
    	   }	

    $server = $svr.Split(",")
    $sql = "ALTER LOGIN [sa] WITH PASSWORD='" + $server[1] + "'"
    Invoke-Sqlcmd -ServerInstance $server[0] -Database "MASTER" -Query $Sql -ErrorAction stop

}

Click on a group of servers in Management Studio SQLServer 2008. Click on "New Query" and you will see at the bottem of the screen that you are connected to all the servers in that group, a server count is displayed instead of a server name, and any SQL will run against all the servers. However, I do like to keep the sa password different on each server.

SQL Multiscript tool is a paid tool, please try for Queryblaster, it does the same functionality as SQL multiscript and its free

Keep in mind that the Central Management Server must be a SQL Server 2008 instance Jorge.