Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • General discussion

  • Discussion
    Sign in to vote
    0
    Sign in to vote

    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