Tip of the Day: Automatic Restore of Table-Triggers RRS feed

  • General discussion

  • I've been setting up Sync Scopes for some time now - a lot of them on ERP systems, that synchronize database model onto the SQL Server - which sometimes needs to delete/recreate tables.

    This is of cause very destructive for the Sync Scopes that rely on Table Triggers, all of which is dropped together with the Table :-(


    The solution for this mess, has in my case been to create DDL Triggers which automatically restore Triggers onto tables, once they have been re-created:

    the solution is posted here:


    Monday, February 7, 2011 12:43 PM