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.

2019-10-10

57 reads

Blogs

Database Fundamentals #24: Filtering Data

By

If you’ve been reading these Database Fundamentals posts, you’ve already seen the WHERE clause...

#PowershellBasics: The Windows Powershell icon in the task bar also lets you run Powershell ISE.

By

I don’t know about you, but I like having the tools that I’m likely...

Launching SQL Compare with Context

By

Years ago Redgate Software started some work to link our tools together. I remember...

Read the latest Blogs

Forums

insert into permanent table using cte

By samirca007

Good morning all I would like to add the result of a multiple query...

Datetime data migration.

By Arjun

Hi All, We are loading data from one of our source table in that...

2012 - 17 Performance Issue

By Matthew24

  Good afternoon everyone, This may sound familiar, but we are yet to find...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Another Typo

See possible answers