[Quote] - 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? [/Quote]
If you do this, you won't capture any data updates done manually. You would be better off disabling the triggers for the night time process then reenabling them afterwards. You can capture certain user data, the information is freely available on the web. On 11 Sep, 23:01, Alex <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
