David Ziffer


SQLServerCentral Article

Creating a generic audit trigger with SQL 2005 CLR

Auditing is becoming more important all the time for DBAs as regulations and requirements increase. Building auditing into your systems can be done a number of ways, but with SQL Server 2005, you have a new option. New author David Ziffer brings us a generic auditing CLR trigger.

3.43 (7)

You rated this post out of 5. Change rating

2006-08-02

19,038 reads

Blogs

March 2025 SQL Challenge: Test Your Skills with Advanced SQL Scenarios

By

If you’re an experienced SQL user eager to sharpen your expertise with real-world challenges,...

SQL Saturday Atlanta BI Recap

By

https://sqlsaturday.com/2025-03-08-sqlsaturday1102/#schedule SQL Saturday Atlanta BI is one of my favorite SQL Saturdays of the...

Mistakes IT Shops Without a DBA Make

By

We get it. There’s no budget for a DBA on staff, or even a...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

SQL 2017 server keeps locking up

By karenhallard

I manage a two-node production SQL cluster running SQL Server 2017 CU31 on Windows...

Alternatiives to Junk Dimensions

By Lord Slaagh

Hello SSC, I am not sure if I posted this in the right spot,...

Visit the forum

Question of the Day

Partial Backups II

What is a partial backup for a read-write database?

See possible answers