When I execute the following code, where RemoteServer is a linked server,
EXEC RemoteServer.msdb.dbo.sp_help_job
it works fine.
How ever, when I try : EXEC LOCALServer.msdb.dbo.sp_help_job, I get
Server: Msg 8164, Level 16, State 1, Procedure sp_get_composite_job_info, Line 67 An INSERT EXEC statement cannot be nested.
It looks like a bug to me. Other wise how could it let the Insert Exec be nested across the servers, but not on the local servers? Is there any way I can work around this on the local server?