A user was doing some processing yesterday evening and it failed after 20 minutes.
The log said that the object had changed since the process started.
I knew this process fell outside of my maintenance window that recompiles/updates stats etc so I investigated.
I found that just before the process failed SQL ran sp_recompile.
I can't see any SQL maintenance tasks that run any time near the user was working so was wondering what would have spawned this?
It was run from the mssqlsystemresource DB. At this time I see deadlocks for the users process.
I have never struck this issue before.