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: 3026 File Size: 2.6kB
Posted By: eralper Views: 13111
Date Added: 8 Jan 2008
Hi,

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

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