Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

An INSERT EXEC statement cannot be nested Expand / Collapse
Author
Message
Posted Thursday, October 31, 2013 12:06 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, April 17, 2014 12:54 AM
Points: 606, Visits: 812
Hi All,

While executing sp, i am getting this error,

Msg 8164, Level 16, State 1, Procedure AxSp_AccAchievement_Report, Line 197
An INSERT EXEC statement cannot be nested.


I identified this issue, i am posting procedure result into hash table in Multiple level.

But for this issue any other ways to resolve this?
Post #1510028
Posted Thursday, October 31, 2013 4:06 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 4:24 AM
Points: 286, Visits: 539
You really need to post your code for anyone to help with a specific answer.

MCITP SQL 2005, MCSA SQL 2012
Post #1510090
Posted Thursday, October 31, 2013 7:44 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 1:13 PM
Points: 958, Visits: 1,285
The simple answer to this problem is you are already performing an INSERT EXEC which is in the stored procedure you are calling, just as the error indicates.

Kurt


Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY

http://www.linkedin.com/in/kurtwzimmerman
Post #1510179
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse