Thanks for your reply. Yes, I have create a test scenario making sure there is some data; your queries give indeed some result.
Also when I just execute this ...
EXEC msdb..sp_dbmmonitorresults
@database_name = 'NAV_Mirroring'
,@mode = 0
,@update_table = 1
... I get/see the desired data. But now I want to save this into a #table; but when I try this, I get this "nesting INSERT EXECUTE" error ...
But maybe there would be a different way? Actually all this is to finally read the "time_behind"!
Is there an easier way to retrieve this info?
Jörg A. Stryk
MVP - MS Dynamics NAV