Modification to Automate Audit Trigger Generation

This is a modification to Automate Audit Trigger Generation at http://www.sqlservercentral.com/scripts/contributions/1073.asp by walkerjet. The changes were made to accommodate tables using different types for their primary keys, (i.e. int, smallint, char, etc.), add the ModifiedById and DTStamp columns, exclude legacy tables that do not have a primary key defined, exclude fields of type text, ntext, […]

2004-10-19 (first published: )

348 reads

Blogs

Regression Testing SQL Saturday Naming

By

I started a poll today on the naming for future SQL Saturdays. You can...

Daily Coping 9 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Error creating Azure SQL Database

By

A quick post today, quite simply, the error message is: “code”: “ConflictingDatabaseOperation”,  “message”: “Operation on server x and database y is in progress.  Please wait a few minutes before trying again.” What...

Read the latest Blogs

Forums

RunningTotal column not working

By luissantos

Hello, I need a little help with my query because they don´t work properly...

Splitting a group up into multiple groups using a score....

By Rob Reid-246754

Splitting a group up into multiple groups using a score for how many times...

Whether to leave a clustered index on a staging table

By DamianC

Hi Using dataflows to load data from one SQL table to another (seperate databases;...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers