sqlscriptingssmssql-server-2008

Is it possible to script the creation of registered servers in SSMS 2008?


I have about 60 servers that I want to add as Registered servers for quick access. They are similarly named...is there a way to script this so I don't have to go through the wizard 60 times? Thanks!

P.S. I did check the XML file and it looks like a beast. Not sure if copying and pasting 60 times is what I want to do...


Solution

  • If you're comfortable in PowerShell, it can be done that way. See Registering SQL Servers in 2000 EM, 2005 SSMS, and 2008 SSMS for a starting point.