delete job

From: Emsga (emsga_at_libero.it)
Date: 05/27/03


Date: Tue, 27 May 2003 03:06:19 -0700


Hi,
I have this problem: someone deleted a job on my SQL 7.0
I'd like to find out when the delete occured and who
was the user (ip of the machine or user id where the
operation was done).
Exist a system/user table that contains this information?
The audit level on this SQL is none.
I hope this is possible and if someone tells me how it
would be really appreciated.

Emilio



Relevant Pages

  • Re: Audit Log in Yukon
    ... Do you mean the Audit Level server setting that writes entries to the SQL ... Error Log? ...
    (microsoft.public.sqlserver.tools)
  • Error 21023
    ... I right click on the SQL ... ALL under Audit level. ... Configuration option 'show advanced options' changed from ... services...but I still get the error message when I ok ...
    (microsoft.public.sqlserver.security)