I know triggers aren't supported by the DDT yet, but here is my issue.



I have triggers in my SQL database, I just updated a table in the DDT to add some fields and deployed it to the server, it erased all my triggers.



How can I avoid this? I thought the rule was if the DDT doesn't need to update something it leaves it alone?

Keith Chisarik

I am not sure why it is wiping them out.  We will have to look at this.  If the triggers are being stored off as sprocs or views then, yes, they will get removed.  The DDT always removes and updates the sprocs and views.  But we will look into it.