CodeSmith Community
Your Code. Your Way. Faster!
Gallery » CodeSmith » Templates » SQL Server Audit Tables and Triggers

SQL Server Audit Tables and Triggers

Previous | Next | View all files | View Slideshow
posted by Jamison
08-24-2007
Downloads: 557
File size: 6.8kB
Views: 2,192
SQL Server Audit Tables and Triggers

CreateAuditTablesAndTriggers.cst creates audit tables and triggers for the selected tables. Uses a one audit table per source table strategy. Timestamp columns are ignored. <cheese>To get around a SQL Server issue with text and ntext columns in the "inserted" and "deleted" tables, only "inserted" data is logged.</cheese>Tested with MS SQL Server 2000.

Comments

Jamison wrote re: SQL Server Audit Tables and Triggers
on 08-24-2007 2:39 PM
Yes, I am shameless. I rate my own scripts. J
malcolm.daughtree wrote re: SQL Server Audit Tables and Triggers
on 11-25-2007 11:54 PM
Sweet ! Thats OK I'll rate it for ya ! :-} 6/5
Copyright © 2008 CodeSmith Tools, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems