SQL 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: )

584 reads

Blogs

Power Platform Quick Tips – Episode 03: Documenting Power Automate Flow Logic

By

Welcome back to my series on Power Platform quick tips! In this episode you...

State of Database DevOps Survey

By

Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe...

HP is the 2019 Laptop Winner

By

This is for me, not necessarily for you, but I decided to go with...

Read the latest Blogs

Forums

SQL Monitoring

By SQLEYES

Hi All, I have SQL 2012 instance on a vm server  which I am...

I can't Uninstall SQL Server 2016

By sirkinghorse

Hi, I have SQL Server 2016 installed in my machine but I can't uninstall...

Log Shipping - What has changed

By nwood2009

We currently have a situation with a vendor where they will only give us...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers