Re: delete job

From: emsga (emsga_at_libero.it)
Date: 05/28/03 

Date: Wed, 28 May 2003 04:34:10 -0700

tanks!

>-----Original Message-----
>Your only real chance is to examine the transaction log
for the msdb
>database using Log Explorer from www.lumigent.com but
since by
>default msdb is set to simple recovery there's no
guarentee the records
>are still going to be there. But to answer the question,
by default there
>isn't any system table that would audit this.
>
>--
>HTH
>
>Jasper Smith (SQL Server MVP)
>
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"Emsga" <emsga@libero.it> wrote in message
>news:2f0301c32437$9e43f1c0$a401280a@phx.gbl...
>> 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: delete job
    ... Your only real chance is to examine the transaction log for the msdb ... Jasper Smith (SQL Server MVP) ... > The audit level on this SQL is none. ...
    (microsoft.public.sqlserver.security)
  • Re: Stored Packages - MSDB Access
    ... I have written the SSIS Project and created the ... I have successfully deploy the package to MSDB, ... can not browse MSDB either locally on the server from SQL Server Management ... why is it saying that anything about remote ...
    (microsoft.public.sqlserver.dts)
  • Re: Transaction log and tempdb
    ... - Is it possible to reduce the size of the transaction log fil during ... an execution? ... It sounds as if you are the database is in full recovery. ... If I execute that script sql server seems ...
    (comp.databases.ms-sqlserver)
  • Re: Stored Packages - MSDB Access
    ... I have successfully deploy the package to MSDB, ... can not browse MSDB either locally on the server from SQL Server Management ... why is it saying that anything about remote ... The MSDB node under Integration Services->Stored Packages refuses to open. ...
    (microsoft.public.sqlserver.dts)
  • Re: Transaction log problems
    ... IF you have to shrink a database or file it ... sure that you get that database backup on tape or to another machine. ... > We are using SQL Server 2000 on Windows Server 2003 Standard Edition, ... > One of the databases has recently begun showing large growth of the> transaction log and it is causing us some problems. ...
    (microsoft.public.sqlserver.server)