Hi Friends,
My requirement is to make Audit table something like having columns FieldName,oldValue,NewValue,TableName,PK_id ,Action.
I want log of any insert/Update in multiple table using trigger.
Thanks
Google is a better place to find answers. What you want is Change Data Capture (CDC). Manually written Triggers are not the way to go. Come to this forum when you've wrote some code and get stuck.
https://www.google.com/search?q=sql+server+cdc&ie=utf-8&oe=utf-8&client=firefox-b-1
EDIT: You also put this in the Oracle, MySQL, Sybase, Informix and other databases forum. There is a separate forum for SQL Server.
https://forums.asp.net/1226.aspx/1?SQL+Server+SQL+Server+Express+and+SQL+Compact+Edition