SQLTeam.com | Weblogs | Forums

Details of the transactions in Sql Server 2008 R2

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.