• You could use an SSIS package, as described here:

    http://www.sqlservercentral.com/blogs/sqlstudies/2012/10/31/looping-through-multiple-servers-in-ssis/