How to fetch the transaction activities/logs for a specific table?

I can see the transaction logs with fn_dblog, but I need to do this for specific table. How can I do that?

You could try the following:

Retrieve the id for your user table:

SELECT id, name FROM sys.sysobjects WHERE NAME = ''

e.g. 658101385

Retrieve the Transaction Log information with the undocumented function:

SELECT * FROM ::fn_dblog(NULL,NULL) WHERE [Lock Information] LIKE '%658101385%'

And then carry on from there.

Reference: Identifying Object Name for CREATE and ALTER Using fn_dblog()

StackExchange Database Administrators Q#185678, answer score: 6