Viewing 2 posts - 1 through 2 (of 2 total)
Just try searching for [Transaction Name] LIKE '%delete%'.
That is OPERATION 'LOP_DELETE_ROWS' will not have have the login info, where as "LOP_BEGIN_XACT" for that delete will have.
Sample query
SELECT
...
December 23, 2012 at 8:26 pm
#1571213
Delete the schedule for the agent jobs realated to the maintenance plans. And you will be able to delete the maintenance jobs with out errors.
The fk error is because,...
June 17, 2010 at 3:20 am
#1181420