Hi, I've been asked to create an audit log of numerous tables showing all updates, deletes, and inserts, so I'm trying to find the simplest way to do this. I found the below article on SQLJunkies.com that actually works great, but I need to make some modifications so it fits into our application: http://sqljunkies.com/Article/4CD01686-5178-490C-A90A-5AEEF5E35915.scuk
Some questions to those more familiar with CLR than I... This script works, but I'd like to see if it's possible to add these modifications: - Due to nightly processes hitting most of our tables, a Trigger really won't work because we don't want that logged. So I was wanting to call the assembly from our Update, Insert, and Delete stored procedures instead. Is this possible? - Also I need to add IP Address, User ID, and a few other parameters to the audit table. How easy/hard is it to modify the assembly to get these as parameters and add them to the Audit table? Thanks for any advise... Alex --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://cm.megasolutions.net/forums/default.aspx -~----------~----~----~----~------~----~------~--~---
