Brahmanand Shukla

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.

2.33 (3)

2019-10-15 (first published: )

647 reads

Blogs

SSAS Tabular – Process Add memory consumption

By

For me it’s a bit surprising how little information can be found regarding the...

Our SQL Server 2019 Administration Inside Out Fun Author Survey

By

SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...

What's New in SQL 2019? at the Data Architecture Virtual User Group and Q&A followup

By

Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...

Read the latest Blogs

Forums

Concat XML field values ?

By jbalbo

Hi I have the XML field  below I need to concatenate the "Purpose of...

convert string + add '.'

By samirca007

Hello Please help me (how to modify a character string in sql server 2017)...

How to populate Temp table from Stored Procedure

By rkordonsky 63916

I am trying to put the result of Stored Procedure execution into Temp Table:...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers