SQL Audit

Technical Article

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2019-10-15 (first published: )

3,180 reads

Blogs

The Book of Redgate:A Prehistory

By

I’ve covered the values in a number of previous posts on the Book of...

Evidence-bound: what AgentDBA will and won’t link

By

When the evidence names the database, it says so. When it doesn’t, it stops....

Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?

By

Making Data AI-Ready, Part 3 (This is the final article in a three-part series...

Read the latest Blogs

Forums

DanDan Jl Panjang Cidodol | WA:083121526888

By Layanan BCA 24 JAM

Jl. Cidodol Raya No.46, RT.6/RW.6, Grogol Sel., Kec. Kebayoran Lama, Kota Jakarta Selatan, Daerah...

DanDan Kavling Polri | WA:083121526888

By Layanan Bank BCA

Kavling Polri, Jl No.1601 Blok F 8, RT.8/RW.02, Jelambar, Grogol petamburan, West Jakarta City,...

Toko Kosmetik Sumber Ayu | WA:083121526888

By Layanan Bank BCA

Pasar Tomang Barat (Pasar Kopro) Lt Dasar Blok B-48, RT.14/RW.5 (depan parkiran motor), Tanjung...

Visit the forum

Question of the Day

Hyperscale Replicas III

In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?

See possible answers