I need following details:
Username of the user who initiated the transaction
Origin of the query i.e. Whether Query executed in SQL server New Query Interface or Transaction due to editing in Table or Via any other application.
I know that all the transactions are saved in .ldf file. Using sql query/other tools i was able to fetch some details but not all the above for all transactions. Is there any way to get all the above information for all transactions.