Help needed for Sql2005 Transaction Logs

Hi,

I have run a lot of insert/ delete, update queries on a database in sql 2005 for a couple of months

Is there a way to track when and what are sql transactions that are have been executed?

Thanks in advance for your time and help.

whitze

You can monitor the activity in your database by running sql profiler........but this can be performed when you want to identify the bottlenecks in your db or in your server.........but it is not advisable to run it always....if you have the trace which is captured when those DML's were performed you can track it .......else i dont think its possible..........im not too sure about it......|||

If you have a complete trail of the Transaction Logs, you could use one of the several third party log tools to accomplish your task.

If you do not have a complete trail of Transaction Logs, then most likely, you will not be able get that information.