Member Avatar for MARKAND911

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?

  • 3 Contributors
  • 4 Replies
  • 111 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by crishjeny
Member Avatar for debasisdas

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

Member Avatar for MARKAND911

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.