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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-15 : 13:04:51
|
Carlos writes "Ok, before I'll try to set a picture of what I am doing. I am working with three stored procedures:
I have a store procedure A (sprA). Somewhere, I call:
.
.
-- create temporary_table1 (a,b,c...
Exec sprB @varA, @VarB, @VarC
INSERT #temporary_table1
.
.
The sprB does this internally:
--create temporary_table2 (a,b,c...
INSERT #temporary_table2
EXEC sprC @varA, @varB, @VarC
--(note these variables are being passed by sprB
--The sprC, as you may already guessed, returns also
--a set of records.
And when I try to run this, gives me...
errmsg Msg 8164: Procedure sprB, Line NN
"Eine INSERT EXEC-Anweisung kann nicht geschachtelt werden." or
"A INSERT EXEC-instruction can't be executed"
And ErrMsg 3916: Procedure sprB, Line NN
"COMMIT-Anweisung kann in einer INSERT-EXEC-Anweisung nur verwendet werden, wenn zuerst BEGIN TRANSACTION verwendet wird." or
"COMMIT-instruction can only be used inside a INSERT-EXEC only when a BEGIN TRANSACTION has already been used"
The little fact is that I NEVER use any transactions at all, I rely it all to my EXEC INTO commands.... any Idea?
Thanx" |
|
|
|
|
|
|
|
Problem with