-- Drop "temp" tables. If the table exists the error will be raised.
-- The new tables will be created automatically based on the schema of the query result 
IF OBJECT_ID('dbo.tmp_Test')		IS NOT NULL DROP TABLE dbo.tmp_Test
IF OBJECT_ID('dbo.tmp_TestError')	IS NOT NULL DROP TABLE dbo.tmp_TestError	-- Special table to keep all the errors

	-- This sp doesn't return any resultset, but saves the result into 2 tables
	-- Parameters:
	-- @serverNames			-- Either semicolon separated list or a valid SQL query
	-- @sqlquery			-- Query that will be executed on the servers. If the schema of resultset is different on the servers the procedure will fail
	-- @targetTable			-- Table to store the result. Will be created automatically
	-- @targetErrorTable	-- Table to store all the errors. Will be created automatically or reused if already exists
EXEC dbo.sp_RunQuerySQLServers
	@serverNames = 'select name, server_id as id from msdb.dbo.sysmanagement_shared_registered_servers_internal',
--  SQL Auth
--	@serverNames = 'select name, server_id as id, ''sa'' as login, ''###%%%$$$$'' as password from msdb.dbo.sysmanagement_shared_registered_servers_internal',
	@sqlquery = 'select sum(size/1024)*8/1024 GB from sys.master_files', 
	@targetTable = 'dbo.tmp_Test', 
	@targetErrorTable = 'dbo.tmp_TestError'

-- Results
SELECT * FROM dbo.tmp_Test ORDER BY [@ServerName]
SELECT * FROM dbo.tmp_TestError

-- Drop "temp" tables
IF OBJECT_ID('dbo.tmp_Test')		IS NOT NULL DROP TABLE dbo.tmp_Test
IF OBJECT_ID('dbo.tmp_TestError')	IS NOT NULL DROP TABLE dbo.tmp_TestError	-- Special table to keep all the errors