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 - 2005-01-04 : 08:42:27
|
| rabin writes "Hi,I wrote an insert trigger on Table1 to update a field of Table2. Inside the trigger, a cursor is declared on Inserted table and a while loop is used on the basis @@Fetch_Status value to go through the each inserted record.The trigger works properly for several years. But oneday it was revealed that the field of Table2 was not updated accordingly although related record is inserted into Table1. I looked into the matter and found that inside the trigger, @@Fetch_status retured -1. That is, the cursor is not populated properly.Would anybody pls help me regarding the matter.NB. I submitted this topic earlier. Getting no reply, I'm resending it." |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-01-04 : 10:08:58
|
| Several Years....ummm, you sure?You probably didn't get a response because a cursor in a trigger sounds like a bad idea...Can you post the trigger so we can see it?Brett8-) |
 |
|
|
|
|
|
@@Fetch_Status shows -1