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

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


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.