Post reply

Audit SQL Server Service Recycle

  • February 17, 2008 at 11:28 pm

    #182184

    Is it possible to know which user had recycled the SQL Server Services (using the SQL Server Service Manager) in MS SQL Server 2000?

    Thanks in advance,

    Pradeep

  • February 18, 2008 at 8:22 pm

    #779537

    I don't think so, since restarting services is an OS-level event rather than an application level event.

    You'd have to have security auditing configured on Windows & check the Security Event Log to see who connected around the time the services were restarted.


    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare

  • February 18, 2008 at 8:27 pm

    #779538

    Thanks Scott. Even I checked the security log, still could not figure out. I am just wondering is there any better way to find this out.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • February 25, 2008 at 1:09 pm

    #781730

    check out the system event log for this

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply