February 23, 2009 at 10:29 am
I read that to track data changes in SQL 2005, I'll need a trigger. I need help creating the trigger and having it work.
Example: I need to track data changes on table 1, columns A, E and F
I need to know what the change was, who made the change and the date and time the change was made.
Is there another easier way to track data changes??
February 23, 2009 at 10:39 am
A trigger will do this, or you can read the log later if you buy a tool.
http://www.sqlservercentral.com/articles/Security/sqlserverauditingpart1/1451/
February 23, 2009 at 11:10 am
I would need the T-SQL script for creating the table that will hold info on data changes and creating the trigger using the table and columns I gave in the example.
February 23, 2009 at 11:27 am
Check out these articles, and the discussions. Plenty of sample code to set up audit logging.
http://www.sqlservercentral.com/articles/Auditing/63247/
http://www.sqlservercentral.com/articles/Auditing/63248/
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply