Disable Trigger

dineshasanka

I have tabel which I want to deploy to the customers site. this table has a trigger which will create data in the other table.

When I used script from the SQL Packager, it does disable the triggers. because of this when data is inserted secondory table all filled with data.

Brian Donahue

Hello Dinesh,

Disabling triggers is an option, so if you can decide how you want the package to behave, then you can either run with the triggers enabled or disabled. The option appears under SQL Options->Data from the menu. If you are synchronizing both the table with the trigger and the table that the trigger updates, you will want to disable the trigger. If you want to let the trigger update the second table, then you'd exclude the second table's data from the package and allow the trigger to update it.

Hope this helps!