Tracking users in 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Tracking users in 2005

is there any way in SQL Server 2005 to find out who cancelled/disabled the maintenance job(i.e backup jobs)?
Someone at work diabled the jobs and i am trying to find out who did tht thanks

I don’t think this kind of history is stored in msdb anywhere.<br /><br />first order of business would be to lock the server down so this doesn’t happen again. [<img src=’/community/emoticons/emotion-5.gif’ alt=’;)‘ />]<br /><br /><hr noshade size="1"> <br />
In SQL Server 2005, you can use DDL triggers to track a lot of similar activity, but you have to write your own code. This information is not stored by default. ————————————————————–
Brad M. McGehee, SQL Server MVP
Technical Editor/Moderator www.SQL-Server-Performance.Com
Director of DBA Education for www.Red-Gate.Com
As explained there is no way to retrieve such information, either you have to use third party tools to chekc the transaction log for events (which is a laborious job to perform), also you might need to deploy such DDL triggers which is available since SP2 for SQL Server. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
You can take the help of default trace which keep 5 files of 20MB each size…
These files will be overwritten as needed….if it is highly active server then it is too late…
Moderator All postings are provided “AS IS” with no warranties for accuracy.