Skip to content

Instantly share code, notes, and snippets.

View drasive's full-sized avatar

Dimitri Vranken drasive

  • Switzerland
View GitHub Profile
@drasive
drasive / GenerateAuditTableAndTrigger-MSSQL.sql
Last active January 21, 2016 13:14 — forked from edeustace/sp.AutoGenerateAuditTableAndTrigger.sql
Stored procedure for MS SQL Server to generate history tables and triggers.
/************************************************************************************************************
Inspired by: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=84331
Created By: Bryan Massey
Created On: 3/11/2007
Updated By: Dimitri Vranken
Updated On: 21/01/2016
Explanation:
1) Queries system tables to retrieve table schema for @TableName parameter.