Update trigger or ?

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

.

Relevant Pages

  • Re: Update trigger or ?
    ... process is responsible for it (it's an old installation which I've ... I was thinking about to implement an update trigger but unfortunately ... I've no idea how to figure out the "parent process" which was ... I'm using MS SQL Server 2000. ...
    (comp.databases.ms-sqlserver)
  • [NT] SQL Server Installation Process May Leave Passwords on System
    ... service pack for SQL Server 7.0 or SQL Server 2000, ... without having to actually perform an installation. ... to SQL Server 7.0 Service Pack 4, the passwords were stored in clear text. ... information in the setup.iss and log files would not allow any access. ...
    (Securiteam)
  • Maybe this could help
    ... I've found a solution to update SQL Server to SP3. ... It also works with SP2. ... Product Installation Status ... No mapping between account names and security IDs was done. ...
    (microsoft.public.sqlserver.setup)
  • RE: Error Code: 1073807364 sql server 2005
    ... contain the files that are required during the installation of SQL Server ... In the D:\SQLServer2005 folder, ... Setup.exe to start the SQL Server 2005 Setup program. ...
    (microsoft.public.windows.server.sbs)
  • RE: Error installing (KB 921896)
    ... Package Language: 1033 ... Package Platform: x86 ... Product Installation Status ... to SQL Server. ...
    (microsoft.public.windowsupdate)