FIX: A stored procedure may fail after an automatic failover occurs on a mirrored database in SQL Server

Applies to: SQL Server 2012 EnterpriseSQL Server 2012 DeveloperSQL Server 2012 Enterprise Core More

Symptoms


Assume that you use Microsoft SQL Server ted on a database by using high-safety mode with automatic failover.

If you modify the stored procedure definition, and then you run the stored procedure after an automatic failover occurs, you receive the following error message:

Error: 2801, Severity: 16, State: 1

The definition of object 'stored_procedure_name' has changed since it was compiled.

Resolution


This issue is fixed in the following cumulative updates for SQL Server:

       Cumulative Update 7 for SQL Server 2016 RTM

       Cumulative Update 4 for SQL Server 2016 SP1

       Cumulative Update 6 for SQL Server 2014 SP2

       Cumulative Update 13 for SQL Server 2014 SP1

       Cumulative Update 9 for SQL Server 2012 Service Pack 3     

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.