none
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:

    http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/ce665749-d215-4729-9c4e-9dd77225e68a/

    Monday, February 7, 2011 12:43 PM