Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Using ::fn_dblog() to find who deleted the rows in a table.

    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

    ...

  • RE: Drop failed for jobs

    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,...

Viewing 2 posts - 1 through 2 (of 2 total)