Connect many server SQL

• Valbuenito

  SSC-Addicted

  Points: 436

  More actions

  February 5, 2013 at 3:52 am

  #268123

  Hello,

  I would like to connect many servers on my SQL Server 2008 by the code.

  This would allow me to run a script every morning and don't lose 10min every morning to connect my 20 SQL Servers in my SQL Servers.

  Thanks for your answers 😉

• smamidala

  SSC Veteran

  Points: 213

  More actions

  February 5, 2013 at 3:55 am

  #1584264

  Do you just wanted to connect to all your Servers or perform any activity connecting to servers?

• Valbuenito

  SSC-Addicted

  Points: 436

  More actions

  February 5, 2013 at 4:02 am

  #1584267

  Hello,

  I just want to connect my server with a SQL script to not run twenty times the same manipulation "Login, database engine, my server connect" every morning.

  I would like to find a script as for example:

  Connect Server 1 ...

  Connect Server 2 ...

  ...

  I run every morning and I found my 20 servers on the left side of my SQL Server.

  Cordially

• Richard Fryar

  Hall of Fame

  Points: 3457

  More actions

  February 5, 2013 at 4:35 am

  #1584291

  Add your servers to a group in Registered Servers.

  Then in the morning, right-click on the group and select:

• Object Explorer to open all servers in the Object Explorer pane
• Or New Query to open a query window that is connected to all servers for running a script against them all in parallel


Check Your SQL Servers Quickly and Easily
www.sqlcopilot.com