Posted by Joerg Gempe on 04/23/07 10:25

Hello,

I've a problem where some data gets updated but I don't know which
process (SP) is responsible for it (it's an old installation which I've
taken over).
Is it somehow possible to know which process/user/SP performs an update
on a special table/column?
I was thinking about to implement an update trigger but unfortunately
I've no idea how to figure out the "parent process" which was
responsible for the update.

I'm using MS SQL Server 2000.


Thanks Joerg

• Next in forum: READ UNCOMMITTED data
• Prev in forum: Re: Function Parameter
• Thread view: Update trigger or ?

[Reply to this message]