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 - 2003-05-02 : 07:56:57
|
| Satish writes "Hi!I have a trigger which gets fired when an insert happens.Now I have changed my application in such a way that at regular intervals of time some new records will be appended to the table.I have DTS code for this purpose.Now I have found that the trigger is not getting fired when wver I am appending the records.I have tested the trigger by inserting some records into the table using SQL Query Analyzer.But when the records are being appended to the table then the trigger is not getting fired.I am thinking that as the records were being appended to the table instead of normal inserts the trigger is not getting fired.I would appreciate any help in this issue.Thanks in advance.Regards,Satish Komali." |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-05-02 : 08:39:31
|
| Only 3 options.INSERT AND UPDATE AND DELETE.When you say append you probably mean INSERT.If the triggers for the table have not been turned off and there exists a trigger for insert then it should be firing.Can you post the dml and ddl for trigger and insert statement.Also try the following in QAALTER TABLE YourTable ENABLE TRIGGER YourTriggerthen run your insert and tell us if it's working. |
 |
|
|
|
|
|
Trigger when Appending a record