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 |
|
victory_vishnu
Starting Member
8 Posts |
 Posted - 2008-05-22 : 05:35:19
|
| Hi i have written a new trigger trg_example which will insert the deleted record to another table.how do i enable this trigger , this trigger does not seem to fire |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-05-22 : 05:40:23
|
| You do not have to enable trigger. It fires automatically for given event.Can you post your trigger code here?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
victory_vishnu
Starting Member
8 Posts |
Posted - 2008-05-22 : 05:57:06
|
| Actually there is already one trigger for that table for update , now i have added a new trigger for delete .the update trigger seems to work fine but the delete trigger is not firing .Wat to do? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-22 : 06:15:56
|
quote:
Originally posted by victory_vishnu
Actually there is already one trigger for that table for update , now i have added a new trigger for delete .the update trigger seems to work fine but the delete trigger is not firing .Wat to do?
It will fire automatically whenever a delete action happens on your table. Why do you think its not firing? Can you post code? |
|
|
|
|
|
|
Enabling Trigger in sqlserver2000