Forum Discussion
Read insert/update/delete queries from SQL transaction log file
Read insert/update/delete queries from SQL transaction log file. I am using to read fn_dblog function , using this function I could see only transaction name only not read transaction queries. I thin...
I could see only transaction name only not read transaction queries.
SQL Server don't log the queries, only data changes; so you can't get it.
You have to implement a DML logging.
I want to read that changes from .ldf file ? How? with out CDC and Triggers?
- The function fn_dblog exists, but the usage is not supported and so there is no supported way to get data from transaction log.
