Script Generates Audit Triggers

This script generates a audit trigger for each table in the database. The trigger then logs when each table is updated.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3.67 (6)

You rated this post out of 5. Change rating

2011-11-23 (first published: 2008-05-09)

4,766 reads

Blogs

Setting page visibility and the active page are often overlooked last steps when publishing...

It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...

Recently I was working in VS Code and I saw a walkthrough for the...

Comments posted to this topic are about the item Password Guidance

Comments posted to this topic are about the item Using table variables in T-SQL

I am trying to check out elastic query between two test instances we have...

What happens if you run the following code in SQL Server 2022+?

declare @t1 table (id int);

insert into @t1 (id) values (NULL), (1), (2), (3);

select count(*)
from @t1
where @t1.id is distinct from NULL;