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.

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

More Network Restrictions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item More Network Restrictions, which is...

Moving from RDL to RDLC files in SSRS

By YSLGuru

For any custom reporting in an accounting software program m,y company uses we have...

Gathering Business Requirements and Determining Database Schemas

By CoolKid40

What is simplest way to go about gathering business requirements and determining database schemas?

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Another Typo

See possible answers