Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
subhaoviya
Posting Yak Master
135 Posts |
Posted - 2013-05-08 : 07:21:19
|
while i am calling sp from another sp i am getting error"Cannot use the ROLLBACK statement within an INSERT-EXEC statement." |
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-05-08 : 09:01:28
|
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=82388For sharing data between procedures, there are other ways - see Sommarskog's blog: http://www.sommarskog.se/share_data.html |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2013-05-16 : 01:41:37
|
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 |
|
|
|
|
|