terry999 (8/23/2013)Any ideas what I should investigate next time I'm connected to this machine. Trying to build a list of things to check when I next can access this machine.
Next time when you run profiler include the events "stmtStarted" and "stmtCompleted" from the "Stored Procedures" and "T-SQL" sections. Also include the columns "Error" and "Rowcounts". After the batch has run review the trace and see how many rows were affected by the delete statement and also look for possible ROLLBACK actions.