Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Audit SQL Server Service Recycle Expand / Collapse
Author
Message
Posted Sunday, February 17, 2008 11:28 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, August 19, 2009 2:02 PM
Points: 85, Visits: 35


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
Post #456791
Posted Monday, February 18, 2008 8:22 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:05 PM
Points: 2,644, Visits: 824
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
Post #457170
Posted Monday, February 18, 2008 8:27 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 12:23 PM
Points: 1,618, Visits: 20,977
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
Post #457171
Posted Monday, February 25, 2008 1:09 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 17, 2014 12:34 PM
Points: 1,414, Visits: 4,539
check out the system event log for this

https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #459908
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse