2024-02-21
414 reads
SQL Audit
Generic trigger for maintaining the Audit Log
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.
2019-10-15 (first published: 2019-10-10)
3,110 reads
2019-08-29
612 reads
2019-08-22
804 reads
2016-10-28
899 reads
2010-07-30
2,768 reads
2010-07-23
2,618 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP S. Parman CSTelpon : 0853-73737551
Jl. S. Parman No.184, Ulak Karang Sel., Kec. Padang Utara, Kota Padang, Sumatera Barat...
BCA KCU PADANG CSTelpon : 0853-73737551
Jl. H. Agus Salim No.10 A, Sawahan, Kec. Padang Tim., Kota Padang, Sumatera Barat...
BCA KCP Soekarno Hatta CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. Soekarno Hatta No.RT. 29, Batu Ampar, Kec. Balikpapan Utara, Kota...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers