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 - 2004-05-03 : 10:40:35
|
| Susan writes "I've wrote a trigger that calls a stored procedure. However I does not work. I've tested my stored procedure and it runs correctly. The trigger is working as well. I can see changes the trigger is making to other fields/tables. I know that it actually calls this store procedure due to some tracing and print statements I have placed in the stored procedure. The stored procedures receives parameters from the trigger and does an update statement to a different table then the triggers table.The parameters are being sent in currently (using print I can see what the vaules are within the stored procedure)However, the update statement is not working.I've also tried to just place this update statement within the trigger itself and it will not work. All other statements in the trigger will work except this particular update statement.It this same statement works correctly within the stored procedure when it is not being called by the trigger.This call to the stored procedure is within a cursor in the trigger. Is this the problem?I'm new at this and completely at a lose as to why it's not working.Any help would be greatly appreciated." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-05-03 : 11:33:22
|
| The sores proc will be called within the transaction created by the statement which fires the trigger. I would suspect that is what is causing the problem.Without more details it's difficult to tell.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Triggers /Store Procedures