Browse by Tags

• auditing
• logging
• new features
• programming
• SQL Server
• XML

• Create a Dynamic Logging Trigger With XML

  Triggers are a useful tool for logging DML actions and auditing data changes to tables. But wouldn't it be great if you could write just one trigger and use it on any table? And if the table structure changed the trigger would automatically adjust with no work on your part? With FOR XML and catalog views we can do just that.... Posted Jan 26 2008, 08:47 PM by Mike C with | with no comments Filed under: XML, new features, programming, SQL Server, auditing, logging, trigger