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 - 2006-11-29 : 08:11:18
|
| Mikhail writes "Hi All,i have a simple AFTER INSERT,UPDATE trigger that inserts values to some other table. If I call simple sp from the trigger it only executes for the first record. However, if I write my sql statement directly within the trigger it works fine for all recoreds. Any idea on why it is only executing sp for the first record out of many?Thanks." |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2006-11-29 : 08:35:29
|
Post the trigger code here - so that the people can see.Duane.  |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-11-29 : 09:48:58
|
| Also post the code used in spMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
after insert,update trigger doesn't exec sp