Executer des commandes sql vers de multiples Bases de Donnes en destination

SendCommand.sql

CREATE PROCEDURE ExecuteInMultipleDataBase
	@cmd nvarchar(1000)
AS

declare @databases table (
  name nvarchar(100)
 );

INSERT INTO @databases (name) Values
('AdventureWorks'),('InternetSales');

DECLARE Dbs2 CURSOR FOR
SELECT name FROM @databases;

DECLARE @database nvarchar(50);

OPEN Dbs2;
FETCH NEXT FROM Dbs2 INTO @database;

WHILE @@Fetch_Status = 0
BEGIN
  Exec('USE ' + @database + '; EXEC(''' + @cmd + ''')' );
  FETCH NEXT FROM Dbs2 INTO @database;
END
CLOSE Dbs2;
GO