December 21, 2009 at 5:16 pm
Hello,
I have a database table that I want to track the changes on by creating a log table. I can do the log creation table easily and the a trigger rather easily but I dont want to have to do an UPDATE(fieldname) for each column. I need to capture what column was changed, who changed it, the date it was changed and the old and new values. I've already looked at most of the articles, forum posts and blogs under the Audit triggering and most of those want update(Fieldname) statements. I' ve seen somewhere where a trigger (through information schema) can check to see if the field was changed and only add it to the log if its changed.
Any suggestions
December 21, 2009 at 5:30 pm
Check this thread http://www.sqlservercentral.com/Forums/Topic294216-314-1.aspx#bm299093. It might be what you are looking for.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 23, 2009 at 1:46 am
December 23, 2009 at 9:21 am
Thanks,
I am only using the Express Edition so this option is not available to me.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply