2024-02-21
402 reads
2024-02-21
402 reads
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,077 reads
2019-08-29
605 reads
2019-08-22
797 reads
2016-10-28
895 reads
2010-07-30
2,765 reads
2010-07-23
2,611 reads
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
By Steve Jones
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...
Comments posted to this topic are about the item Create an HTML Report on...
Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through...
Comments posted to this topic are about the item SQL Server Ghosts