I am trying to insert replication-publication status into temp table, but am facing issues.
create table #1(
publisher_db sysname,
publication sysname,
publication_id int,
publication_type int,
status int,
warning int,
worst_latency int,
best_latency int,
average_latency int,
last_distsync datetime,
retention int,
latencythreshold int,
expirationthreshold int,
agentnotrunningthreshold int,
subscriptioncount int,
runningdistagentcount int,
snapshot_agentname sysname,
logreader_agentname sysname,
qreader_agentname sysname,
worst_runspeedPerf int,
best_runspeedPerf int,
average_runspeedPerf int,
retention_period_unit int)
insert into #1
exec sp_replmonitorhelppublication @@SERVERNAME,null
But I get the below error
"Msg 8164, Level 16, State 1, Procedure sp_MSload_tmp_replication_status, Line 80
An INSERT EXEC statement cannot be nested."
I would be grateful if someone can help me finding the solution for this error at the earliest.
