# Sql-server – How to fetch transaction details for Logs Table in SQL Server

sql servertransaction-log

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 (insert and 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 LogTable and ActionData fields.

Please help me to get the name of table on which action performed and the data in string that was affected.