Some application insert record to MyTable using the bulk insert statement
without the clause "With fire_triggers".In MyTable i need that the triggers
fire.
I can't modify the bulk insert statement. How i can fire the triggers on my
table?
thx
In this case, you need to run sp_addtabletocontents to include the rows then
resynchronise. Alternatively you can use sp_mergedummyupdate for a single
row.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Wednesday, March 7, 2012
bulk insert and trigger
Labels:
application,
bulk,
clause,
database,
fire_triggers,
insert,
microsoft,
mysql,
mytable,
oracle,
record,
server,
sql,
statementwithout,
trigger
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment