I want to create a tracking table for changes made to the database.
A tracking table called
Logs must be created into which all changes (
delete) that are made in the database will be entered on the following tables: Author, Publisher, Chapter
The fields of the Logs table will be:
DateOfLog (DateTime) ActionType (varchar (15)) LogTable (varchar (15)) ActionData (nvarchar (max))
I have created the Logs Table as well as writing a trigger to load information in Logs but the problem is with
Please help me to get the name of table on which action performed and the data in string that was affected.