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?
you need to create trigger on each of the events on the base tables.
Can u please elaborate, how can i use triggers to write log file.
good example for SQL Server 2005 Audit Log Using Triggers for generating log while inserting rows in database
We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.