Hi All,I'm tring to catch records being inserted in a SQL server 2k by a hardcoded software.I create a trigger in the first database (say db1) to update a table in another database(db2)both tables are identical(tblA & tblB).CREATE TRIGGER [Update_db2_tblB] ON db1.dbo.tblA FOR INSERTASBEGININSERT INTO db2.dbo.tblBSELECT * from insertedEND
the problem is that i see the db1.dbo.tblA is being filled but db2.dbo.tblB is not updated.since the software that fills db1.dbo.tblA is hardcoded (not open source) I'm not sure about the way it use to do insert.1) I thought triggers not enabled in the database but regardless of wheater it is enabled or disabled I enabled it like this:ALTER TABLE db1.dbo.tblA ENABLE TRIGGER ALL
2) Also I think that software use bulk insert instead of insert.Q1:what things that might be the reason?Q2:how can i control triggers when using bulk insert?Q3: is there any way to insert records without affecting triggers?any other howto, guidance idea would be highly appreciated.thank you all
Triggers Problem
Posted - 2009-09-30 : 05:15:28
