(INSERT EXEC statement cannot be nested.) and (Cannot use the ROLLBACK statement within an INSERT-EXEC statement.) how to solve this??!!
Database
1
Posts
1
Posters
2
Views
1
Watching
-
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.
al hajjaj