Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL server 7.0 logs or other analysis tool

Author  Topic 

cat_jesus
Aged Yak Warrior

547 Posts

Posted - 2001-08-14 : 08:41:57
I have a need to determine exactly what tables are changed and what changes occur on a huge database when a particular process runs. This process only affects a small amount of data so I am searching for a needle in a haystack so to speak.

I was wondering if anyone ever came up with a good way to view the transaction log.

Also if anyone has a good SP for searching for a particular string in the syscomments table, that would be a great help too.

Cat



Edited by - cat_jesus on 08/14/2001 08:44:00
   

- Advertisement -