i need to back track data should there be changes for the last 30 days.
help!
thank you!misheL wrote:
> i need to back track data should there be changes for the last 30
> days.
Are you seriously expecting many posters to respond and take the time
to answer your question considering the amount of time you have put
into formulating your question?
Kind regards,
Stijn Verrept.|||On Tue, 13 Dec 2005 17:30:02 -0800, misheL wrote:
>i need to back track data should there be changes for the last 30 days.
>help!
>thank you!
Hi misheL,
Please provide better specifications. See www.aspfaq.com/5006.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
Showing posts with label track. Show all posts
Showing posts with label track. Show all posts
Monday, March 26, 2012
Friday, March 9, 2012
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.
Subscribe to:
Posts (Atom)