Hi,
Ii would like to store the information(EventDate EventDML LoginName DatabaseName TableName HostName IPAddress ProgramName ) in separate table if any data changes(insert\update\delete) happens in any table in the database.
aAny suggestions please.
Thank you !!
Please take a look at this post, SQL Triggers is used here,
http://www.madeiradata.com/audit-changes-every-table-sql-server/