Verifying tables updated

[morechocolate]

If I had a user enter a transaction and I wanted to see what tables were touched by the transation, what table or system object could I use to determine that? I do not thing sysobjects would be correct.

Thanks in advance for your help.

mc

 

[mrdenny]

The sysobjects table holds a list of all the objects within the database. It has nothing to do with a users transactions.

If you use SQL Profiler and run a trace on the SQL Server it will show you all the commands in real time.

If you get Lumigent Log Explorer (I'm probably spelling the name of the company wrong) it can go into the transaction logs and see exactly what was done historicaly.

Or look at the code, as that will tell you what is being done.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[morechocolate]

Thanks Denny,

I knew I could not use sysobjects, I was just verifying that.

Would look at the code, however, the vendor does not provide us with the source code for their program.

I looked in the sysobjects to get the name of the transaction log, unless I am over looking something I cannot find one. It's a long story with our vendor.

I will see if our DBA can do something with the SQL Server Profiler.

Thanks

 

[mrdenny]

The log won't be in sysobjects. It's not an object within a database, it's a part of the database. Ask your DBA about it.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[MDXer]

you can run SQL profiler when the user transactions are processing. THe right selection of objects to profile should lead you to the info your looking for.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck