Transaction History in SQL SERVER Express

I need to keep Table log in a history table. Can you please suggest me I can get the record from SQL SERVER Log table ?

Or do I need to write trigger for every table and store the data for edit, insert and delete in history table ?

Its a ASP .NET application so I want to store data about the user did the modification and from the IP . Whats the best way to do this ?
Vikash pAsked:
Who is Participating?
 
lcohanConnect With a Mentor Database AnalystCommented:
For DML yes - you would need to put triggers on INSERT/DELETE/UPDATE to generate the Audit(log) records you need to keep.

For DDL you can try use SQL Database DDL triggers meant for that:

http://technet.microsoft.com/en-us/library/ms190989(v=sql.105).aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.