SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software

Development Resources Download Files for Programmer and Administrators

Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.

DDL Trigger for ALTER_TABLE to Synchronize Tables

File Details
Downloads: 3067 File Size: 2.6kB
Posted By: eralper Views: 13277
Date Added: 8 Jan 2008

This is a DDL trigger (Data Definition Language trigger) which can be used in Microsoft SQL Server 2005 databases in order to keep two tables synchronized when one table structure is changed by adding a new column

The DDL trigger uses the EVENTDATA() information and select necessary data from sys.tables, sys.columns and sys.types

The DDL trigger can not be considered to be fully completed but I think it is a good sample to begin with

No comments exist for this file.
Copyright © 2004 - 2018 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems