We have 3 SQL Server 2012 instances, 2 of them we're not
db_owner. Some of our stored procedures use DMV and
sys views and stored procedures that only work when executed locally.
I'd like to centralize the execution of these (our) stored procedures in our main instance, and from it execute these stored procedures remotely. I tried using SQL Server Agent jobs, but it requires some configuration I'm not comfortable doing, and probably won't have access anyway.
Is there any way to remotely execute a stored procedure, preferably using linked server?
Edit: we can use linked server,
openrowset, anything that can be run inside simple SQL. I'd rather not use SSIS, because doing so would separate part of the process from simple SQL and require multiple platforms to run it.