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.

2.33 (3)

You rated this post out of 5. Change rating

2019-10-15 (first published: )

2,735 reads

Blogs

What happens when we drop a column on a SQL Server table? Where's my space?

By

This article was initially posted on SQLServerCentral @ 2024-04-26. Short answer: The column is marked...

Why the masters and what lies ahead

By

I recently graduated with a Master’s in Strategic Communication from the University of Delaware....

Copilot Reminded Me How To Find a File Handle

By

Recently I was trying to delete a folder and kept getting the “something is...

Read the latest Blogs

Forums

LinkedServer error

By Yousaf Khan

I getting the bellow error when runing query on linkedserver from another server after...

Filtered index prerequisites to be used

By Martass

Hello, After few videos and  showing how filtered indexes works, what are the prerequisites...

Enhancing Web Application Performance through Database Optimization: A Comprehensive Study

By nai3

Comments posted to this topic are about the item Enhancing Web Application Performance through...

Visit the forum

Question of the Day

Automated Azure SQL VM Patching

There is an Automated Patching service for VMs running SQL Server in the Azure Cloud. This uses the SQL Server IaaS Agent Extension to work with PowerShell. What types of patches are installed with this service? Note: All updates are marked with tags, such as Important, Critical, or something else

See possible answers