SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 insert-exec issue
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

135 Posts

Posted - 05/08/2013 :  07:21:19  Show Profile  Reply with Quote
while i am calling sp from another sp i am getting error

"Cannot use the ROLLBACK statement within an INSERT-EXEC statement."

James K
Flowing Fount of Yak Knowledge

3849 Posts

Posted - 05/08/2013 :  09:01:28  Show Profile  Reply with Quote
This is a restriction on insert-exec - take a look at the last reply in this thread: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82388

For sharing data between procedures, there are other ways - see Sommarskog's blog: http://www.sommarskog.se/share_data.html
Go to Top of Page

Posting Yak Master

210 Posts

Posted - 05/16/2013 :  01:41:37  Show Profile  Visit prett's Homepage  Reply with Quote
Agree with James K,

I will recommend to take a look at 'How to Share Data Between Stored Procedures' on this post: http://www.sommarskog.se/share_data.html
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000