August 3, 2010 at 3:50 am
I have several jobs in SQL Server 2005, 4 users have access on that. Someone has deleted that job. How can identify that uses, who has deleted the job ? I want to know the user name who has deleted the job.
Thanks in advance.
August 3, 2010 at 5:29 am
You may want to go through the Default Trace of SQL 2005. This article[/url] explains on how to do it.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 3, 2010 at 6:08 am
Does this tracing gives the detail of that user who has deleted the Jobs in SQL server 2005 ?
August 3, 2010 at 7:34 am
The answer was available in the Hyperlink I provided in the previous post. You may query the default trace as per your requirement. However, I have given the below example.
select * FROM ::fn_trace_gettable('C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_19.trc',0) where DatabaseID=4
and TextData is not null
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 9, 2010 at 6:25 am
Hi Pradeep,
As per my client requirement i was asked to take backup and restore the database.
After doing that, suddenly all the 40 jobs failed....
Now, i am facing problem here....any workaround would be great help.....
August 9, 2010 at 6:42 am
What error message do you get?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply