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 |
|
DiceK-BadMan
Starting Member
12 Posts |
 Posted - 2008-05-13 : 02:12:36
|
| I know now how the trigger works, but where I should put the trigger query?I mean in what part, Should i put it along with the stored procedure?If I have enterprise manager(responsible in making new database,etc),where should I include trigger on it?Thanks for the help in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-13 : 02:24:18
|
| Nope trigger is seperate object. Just execute it once in db where your base table exists in your query analyser. Once succesfully executed, it will fire automatically each time the action takes place on your base table and it performs the code written within. |
 |
|
|
DiceK-BadMan
Starting Member
12 Posts |
Posted - 2008-05-13 : 02:37:27
|
| Thanks for your help.Maybe if doesn't work,I will reply in this thread again |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-13 : 04:06:46
|
quote:
Originally posted by DiceK-BadMan
Thanks for your help.Maybe if doesn't work,I will reply in this thread again
No probs. Always happy to help  |
|
|
|
|
|
|
Help in where to put trigger