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?

Recommended Answers

you need to create trigger on each of the events on the base tables.

Jump to Post

All 4 Replies

you need to create trigger on each of the events on the base tables.

Thanx debasisdas.
Can u please elaborate, how can i use triggers to write log file.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.