Can anyone please provide a script using fn_dblog to find Insert/Delete/Update operations with data (like Change Data Capture) that are made to the SQL Server from transaction log.

I can't enable Change Data Capture since I am using SQL Server 2012 Standard Edition.

Change Tracking is not suitable since I need before and after values.


1 Answer 1


Can anyone please explain the script to find Insert/Delete/Update operations with data (like cdc) that are made to the sql server from transaction log.

Free ones of this would be a program and they are generally paid for. There are no free ones that I know of. Additionally the SQL Server Transaction Log is not documented as it is for internal use only.

I cant enable cdc since I am using SQL server 2012 standard edition.

Then either change your edition or go without. You can write your own tracking using triggers, but it's going to make your application run extremely slow.

You really need to look into items that do this, Golden Gate, CDC, CT, etc., and go from there. If you can't spend any money then you need to make a business justification case for it and if still nothing, you can write it using triggers. Note that using triggers is still spending money on development... so either way money is being used.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.