Remote Call insert local table from exec of a remote SP

[JayKusch]

OK .. brain dead for a Friday - lol

So I have a server where I am "trying" to call a remote stored proc to load a local table.

Somthing like ...

INSERT INTO Admin.dbo.MyTable (
  Col1, 
  Col2	)

	EXEC MyRemoteDB.dbo.MySP

Now Admin.dbo.MyTable is the local table and MyRemoteDB.dbo.MySP is the remote SP I want to execute to insert into MyTable.

I want to do this without the use of a dedicated linked server since I have 100+ servers I need to run this against.

Need something like what a OPENROWSET would provide.

Thanks!

Thanks

J. Kusch