InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 10:23:51 GMT20http://www.sqlservercentral.com/Forums/Topic842745-145-1.aspxThanks a lot Jack,can you give some examples on implementing my requirement through sqlcmdor power shellThu, 07 Jan 2010 21:47:25 GMTningaraju.nhttp://www.sqlservercentral.com/Forums/Topic842745-145-1.aspxOptions:1. sqlcmd - create a batch file that uses sqlsmd to connect to each server that executes a saved sql script against each server2. PowerShell - create a script that either has hard-coded connection information for each server or that reads the server information from a table or file and then executes a saved sql script against each connection.3. Buy [url=http://www.quest.com/toad-for-sql-server/]Toad for SQL Server[/url] from Quest as it has multi-server query capability.Thu, 07 Jan 2010 07:22:15 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic842745-145-1.aspxThen what shall i do.. No options at all?:hehe:Thu, 07 Jan 2010 07:11:52 GMTningaraju.nhttp://www.sqlservercentral.com/Forums/Topic842745-145-1.aspx[quote][b]ningaraju.n (1/7/2010)[/b][hr]But we are using 2005 :-)[/quote]That's why I said "IF". MY SQL Servers are all running 2005, but I have the 2008 tools (SSMS) which allows me to use the mult-server query functionality because it is a client functionality. That is also why I mentioned sqlcmd and PowerShell as either of those will work as well.Thu, 07 Jan 2010 06:56:55 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic842745-145-1.aspxBut we are using 2005 :-)Thu, 07 Jan 2010 06:25:47 GMTningaraju.nhttp://www.sqlservercentral.com/Forums/Topic842745-145-1.aspxIf you have SSMS 2008 you can run a multi-server query, see this blog [url=http://blog.sqlauthority.com/2009/06/14/sql-server-2008-ssms-feature-multi-server-queries/]post[/url]. If not you could do a batch file or cmdexec job that uses sqlcmd to connect to each server and run the same code. Or you could use PowerShell to run the same query against each server. For sqlcmd and PowerShell you can save the query in a text file and load the query from there. With PowerShell you can use a file or table to store the servers to connect to and load those up when the script starts.Thu, 07 Jan 2010 06:05:30 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic842745-145-1.aspxThanks Jack,But I don't want to do it manually... So i need query which alters the SP in all different servers at once..Wed, 06 Jan 2010 21:02:41 GMTningaraju.nhttp://www.sqlservercentral.com/Forums/Topic842745-145-1.aspxIf you are using SSMS you need to connect to the other server and then run the statement in the context of the correct database. First you need rights to connect to the other server, then you need rights to create/alter objects in the database.Wed, 06 Jan 2010 07:16:03 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic842745-145-1.aspxDear Friends,I have text of an stored procedure,I want to execute it in different server from my server For Eg:I have SP as ALTER PROC uspGetUserASSELECT * FROM [User]I have to run this query in vijay\sql2005 which is my friends server from my server ie; ningaraju\sql2005Is there an way to accomplish this task? If please do the need fullThanks in advanceWed, 06 Jan 2010 06:48:44 GMTningaraju.n