SQL Server Audit

Generic trigger for maintaining the Audit Log

  • Script

This trigger will work even if you don't have the primary key on any table. Mechanism to configure the primary key in config table has been provided. This can be very helpful to solve the system audit requirements without much efforts.

Disclaimer : Audit Log trigger has performance overhead. It’s meant for table which is not frequently updated, deleted or inserted. Please take precaution when creating the trigger on the table having too many columns.

2.33 (3)

2019-10-15 (first published: )

735 reads

Blogs

Fun Fact: AWS RDS and system_health

By

Did you know that the system_health Extended Event session was running in your RDS...

Daily Coping 2 Jun 2020

By

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

TSQL Tuesday #127 Invite – Non SQL Tips and tricks

By

How about for this months TSQL Tuesday let’s do another month of tips and...

Read the latest Blogs

Forums

SSIS How to split a single string into multiple columns using Derived Column

By sabarishbabu

Hello, In my source Column having comma separated with text qualifier(“), I would need...

Licensing Audit Advice

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Licensing Audit Advice

Getting the Mean

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the Mean

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers