We have a customer that is getting a sporadic issue where users are getting an error that the definition of table 27 has changed. This is simply and easily rectified by re-compiling the object, however we are trying to get to the root of what is causing this error.
From looking at the event viewer, it appears that this is happening out of hours on a Sunday when a third party is running SQL maintenance jobs which makes a backup, updates statistics and rebuilds indexes. We have been in contact with them and they have reviewed the job stating that this job doesn't modify any data. Could the index rebuilding be changing the table definition? Maybe it's affecting the metadata or something along those lines?