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.