SQL Server 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

Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 4

By

This is the fourth and final post in a series about modern Data Lake...

SQLOrlando 2019

By

We just had our final event of the year and looking back, not bad...

Read the latest Blogs

Forums

about system table of sys.dm_db_missing_index_details and sys.dm_db_index_usage_

By 892717952

sys.dm_db_missing_index_details shows we need to create an index based on the columns under equality_columns...

From Source Control to Database using SQL Compare Command Line

By Additional Articles

Comments posted to this topic are about the item From Source Control to Database...

The Schema Name

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Schema Name

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers