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.

thanks... luckily I had a good backup because the syntax on them was a real *****

Keith Chisarik

When I go to recreate them via CREATE TRIGGER scripts it says they already exist, though I cannot see them. They definitely exist because they are doing their job. The just disappeared from SQL management Studio when I ran the DDT deploy, they were definitely there 2 minutes before I did the deploy because I was reviewing their functionality with my boss.



I have rebooted and reloaded everything I could think of, any ideas?



Thanks.


Keith Chisarik

You can delete this entire thread.... there is no problem.



Sorry

Keith Chisarik

Good to hear....I wasn't able to reproduce when I tested it