I am using SQL2008.
I want to generate log file of each and every transaction carried out on my table.
How can i do this?
MARKAND911
-1
Junior Poster
Recommended Answers
Jump to Postyou need to create trigger on each of the events on the base tables.
All 4 Replies
debasisdas
580
Posting Genius
Featured Poster
you need to create trigger on each of the events on the base tables.
MARKAND911
-1
Junior Poster
Thanx debasisdas.
Can u please elaborate, how can i use triggers to write log file.
debasisdas
580
Posting Genius
Featured Poster
crishjeny
-10
Junior Poster in Training
good example for SQL Server 2005 Audit Log Using Triggers for generating log while inserting rows in database
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.