(INSERT EXEC statement cannot be nested.) and (Cannot use the ROLLBACK statement within an INSERT-EXEC statement.) how to solve this??!!

• HAJJAJ

  Old Hand

  Points: 339

  More actions

  September 25, 2010 at 1:52 pm

  #227384

  hi all i have a very important issue,

  read this scenario please

  i have three Stored Procedures Sp1,Sp2 and Sp3 .

  the first one (Sp1) will execute the second one (Sp2) and save returned data into @tempTB1 and the Second one will execute the third one (Sp3) and save data into @tempTB2.

  if I execute the Sp2 it will works and it will returned me all my data from the Sp3 ,but the problem is in the Sp1, when i execute it it will display this Error:

  INSERT EXEC statement cannot be nested

  I tried to change the place of execute Sp2 and it display me another error:

  Cannot use the ROLLBACK statement within an INSERT-EXEC statement.:crazy: