There’s an interesting article at SqlJunkies about how to create a generic CLR audit trigger. But there is just one small problem with this trigger code. The PerformedBy column of the Audit table in the sample code is set to the UserID of the connection string which in most applications would be the...

Here's a very simple way to make use of xml type in SQL Server 2005: audit all the object/schema changes to the database with a simple database-level trigger. It's like a poor man's source control for schema changes. But also, it could come in very handy for forensic purposes when diagnosing post-r...