View recent transactions?

[pdbowling]

Hello, Everyone.

I am supporting some software (no source code) and have run in to an issue where I need to see which tables a particular function in the application is updating/inserting.

Is there a method of maybe turning on transaction logging or..

putting the number of entries in all tables into a temp table and comparing it to the same counts after the process has run?

Neither method above is required, it's just what has come to mind so far. Any pointers would be great.

SQL Server 2008

Thank you
Patrick

 

[philhege]

If you need to investigate on a temporary basis, use SQL Profiler. It will show you the statements the process is using to manipulate the data.

-----------
With business clients like mine, you'd be better off herding cats.