March 29, 2010 at 2:25 pm
Running SQL 2005 Standard Edition, 64-bit, 28GB RAM assigned to SQL. We have 134 databases on this instance. Friday afternoon, around 5:20PM we started getting these error messages in the application:
The definition of object '<stored_procedure_name>' has changed since it was compiled.
The error only happened for 29 of the databases on this instance, and was not consistent in where it appeared for those 29 databases. No database maintenance activities were taking place, and the stored procedures had not been updated for a month or longer.
The fix, weird as it may sound, was to go back into that database and mark that stored procedure for recompile.
Has anyone seen anything like this before? I pretty regularly go through and update statistics, and then mark all stored procs for recompile, and don't run into this. I've spent the better part of today looking around the internet trying to find something similar and am still scratching my head. The stored procedures are all fairly straightforward, not doing anything like altering a table, etc.
David
March 29, 2010 at 2:42 pm
owen983 (3/29/2010)
Running SQL 2005 Standard Edition, 64-bit, 28GB RAM assigned to SQL. We have 134 databases on this instance. Friday afternoon, around 5:20PM we started getting these error messages in the application:The definition of object '<stored_procedure_name>' has changed since it was compiled.
The error only happened for 29 of the databases on this instance, and was not consistent in where it appeared for those 29 databases. No database maintenance activities were taking place, and the stored procedures had not been updated for a month or longer.
The fix, weird as it may sound, was to go back into that database and mark that stored procedure for recompile.
Has anyone seen anything like this before? I pretty regularly go through and update statistics, and then mark all stored procs for recompile, and don't run into this. I've spent the better part of today looking around the internet trying to find something similar and am still scratching my head. The stored procedures are all fairly straightforward, not doing anything like altering a table, etc.
David
Are you using Synonyms over linked servers? http://sqlblogcasts.com/blogs/sqldbatips/archive/2008/10/20/view-plus-synonym-plus-linked-server-plus-table-equals-trouble.aspx
-- Cory
March 29, 2010 at 2:45 pm
No, no synonyms. Very straightforward stuff.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply