Home Forums SQL Server 2005 Administering Registering 300+ SQL Servers to management studio from a list RE: Registering 300+ SQL Servers to management studio from a list

  • WayneS (11/30/2010)


    If you're using SSMS 2008, there is another neat trick. In the Registered Servers panel, ake separate folders for each logical (to you) group. Then, you can right-click the group, select "New Query", and a query window opens up connected to all of the servers. Run something like "SELECT @@ServerName", and you'll get responses from all of the servers.

    always knew about that, but never actually tried it, cool!