I agree with you. Thanks for your suggestions.

However, i have one doubt about trace. Is it possible to track the changes (old value / new value) done to a...

Hi dave,

My preliminary aim to present the application level user with reports showing tracts the changes to the table(data) and the related user info who did it.

But the trace option...

Hi phill,

Thanks for your reply. I am referring to "table level changes" as audit log.

TIA

Kumar

Hi phill,

Thanks for your reply. I am referring to "table level changes" as audit log.

TIA

Kumar

Thank you, Your suggestion helped me out of the problem. The only modification I made to your query was to use an INNER JOIN instead of a CROSS JOIN. A...

Hi steve,

We don't understand what

"Is SQL Server running under a domain account? ". Can you please explain it a bit more.

Thank you,

Suresh Kumar.N

You are in luck. I thought I was runnign SQL 2K with SP2 and found I

wasn't, thus I got an error. Found that this is a known issue corrected

with SP1...