The penultimate audit trigger framework

Posted by Piotr Rodak on SQL Blogcasts See other posts from SQL Blogcasts or by Piotr Rodak
Published on Mon, 10 May 2010 23:18:00 GMT Indexed on 2010/05/11 0:14 UTC
Read the original article Hit count: 644

Filed under:

trigger

|

Tips and Tricks

|

t-sql

|

Numbers table

|

Tally table

|

source code

|

util

|

script

|

api

|

audit framework

So, it’s time to see what I came up with after some time of playing with COLUMNS_UPDATED() and bitmasks. The first part of this miniseries describes the mechanics of the encoding which columns are updated within DML operation. The task I was faced with was to prepare an audit framework that will be fairly easy to use. The audited tables were to be the ones directly modified by user applications, not the ones heavily used by batch or ETL processes. The framework consists of several tables and procedures...(read more)

© SQL Blogcasts or respective owner

Related posts about trigger

consistency of Trigger Procedure (before row trigger) Postgresql

as seen on Stack Overflow - Search for 'Stack Overflow'
Using Postgresql. I try to use TRIGGER procedure to make some consistency check on INSERT. The question is ...... whether "BEFORE INSERT FOR EACH ROW" can make sure each row to insert "checked" and "inserted" one after another? do I need extra lock on table to survive from concurrent insert? check… >>> More
mutating, trigger/function may not see it- error during execution of trigger

as seen on Stack Overflow - Search for 'Stack Overflow'
CREATE OR REPLACE TRIGGER UPDATE_TEST_280510 AFTER insert on TEST_TRNCOMPVISIT declare V_TRNCOMPNO NUMBER(10); CURSOR C1 IS SELECT B.COMPNO FROM TEST_TRNCOMPVISIT A, TEST_TRNCOMPMST B, TEST_MEMMAST C WHERE A.COMPNO=B.COMPNO AND B.TRNMEMID=C.MEMID AND C.MEMOS=1000; begin open c1; fetch c1 into… >>> More
Behaviour of insertion trigger when defining autoincrement in Oracle

as seen on Stack Overflow - Search for 'Stack Overflow'
I have been looking for a way to define an autoincrement data type in Oracle and have found these questions on Stack Overflow: Autoincrement in Oracle Autoincrement Primary key in Oracle database The way to use autoincrement types consists in defining a sequence and a trigger to make insertion… >>> More
Returning Identity Value in SQL Server: @@IDENTITY Vs SCOPE_IDENTITY Vs IDENT_CURRENT

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
We have some common misconceptions on returning the last inserted identity value from tables. To return the last inserted identity value we have options to use @@IDENTITY or SCOPE_IDENTITY or IDENT_CURRENT function depending on the requirement but it will be a real mess if anybody uses anyone of these… >>> More
Returning Identity Value in SQL Server: @@IDENTITY Vs SCOPE_IDENTITY Vs IDENT_CURRENT

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
We have some common misconceptions on returning the last inserted identity value from tables. To return the last inserted identity value we have options to use @@IDENTITY or SCOPE_IDENTITY or IDENT_CURRENT function depending on the requirement but it will be a real mess if anybody uses anyone of these… >>> More

Related posts about Tips and Tricks

3 Tips of SEO That Will Make You Money - Search Engine Optimization Tips

as seen on Ezine Articles - Search for 'Ezine Articles'
You need to make sure your marketing methods rank high in the Google and Yahoo search engines; to do this you're going to need to understand search engine optimization. Here are 3 SEO tips. >>> More
More Linux Tips and Tricks

as seen on Internet.com - Search for 'Internet.com'
we learn how easy it is to configure OpenSSH to use secure public key authentication instead of a password login. >>> More
More Table View Tricks for the iPhone

as seen on Internet.com - Search for 'Internet.com'
Go beyond the basics of the iPhone Table View with examples for grouping rows into sections, displaying an index on the side, and adding a Search Bar. >>> More
More Table View Tricks for the iPhone

as seen on Internet.com - Search for 'Internet.com'
Go beyond the basics of the iPhone Table View with examples for grouping rows into sections, displaying an index on the side, and adding a Search Bar. >>> More
SQL SERVER – Fix : Error 3623 – An invalid floating point operation occurred

as seen on SQL Authority - Search for 'SQL Authority'
Going back in time, I always had a problem with mathematics. It was a great subject and I loved it a lot but I only mastered it after practices a lot. I learned that mathematics problems should be addressed systematically and being verbose is not a trick, I learned to solve any problem. Recently one… >>> More