Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2009
    Posts
    1

    Cool Unanswered: Insert exec statement cannot be nested

    Hi,

    I have a problem with executing Transact-SQL at SQL2005.
    I am trying to capture sp_replmonitorhelpsubscription output info using a temp table, but it saying ''Insert exec statement cannot be nested''.

    Is there any workaround to resolve this issue.

    Thanks,
    Vamshi

  2. #2
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    What was your script?
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  3. #3
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    there is a workaround, but it's a bit lame. you have to use OPENROWSET.

    see: An INSERT EXEC statement cannot be nested: Executing system stored procedure

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •