SharePoint 2010: "Could not find stored procedure" error after you install SP1

Applies to: Microsoft SharePoint Foundation 2010SharePoint Server 2010


You have a Microsoft SharePoint Server 2010 or Microsoft SharePoint Foundation 2010 environment that was upgraded to Service Pack 1 (SP1). The following error may be logged in the Application log of one or more SharePoint servers in the farm on a periodic basis:

Log Name:     Application
Source:        Microsoft-SharePoint Products-SharePoint Foundation
Date:       <Date and Time>
Event ID:      5586
Task Category:    Database
Level:        Error
User:       Domain\Username
Computer:     Servername
Unknown SQL Exception 2812 occurred. Additional error information from SQL Server is included below.

Could not find stored procedure 'proc_UpdateStatisticsNVP'.
<Date and Time>T00:00:13.143: Starting
<Date and Time>T00:00:13.143: Dropping automatically created stats on user tables
<Date and Time>T00:00:13.143: Updating statistics on user indices
<Date and Time>T00:00:13.150: Statistics for dbo.IX_Dependencies_ObjectId are now being updated with default sampling.
<Date and Time>T00:00:13.150: Rebuilding
<Date and Time>T00:00:13.153: Done
<Date and Time>T00:00:13.153: Statistics for dbo.IX_Objects_Version are now being updated with default sampling.
[Further details of the entire error text omitted]


The SharePoint 2010 Health Analyzer consists of a health rule that has the title "Databases used by SharePoint have outdated index statistics." This rule runs on a daily schedule and checks the SharePoint databases for outdated index statistics. If database index statistics are outdated, the rule automatically tries to update the database statistics. The error is generated because the health rule tries to run the proc_UpdateStatisticsNVP stored procedure against the configuration database. However, this stored procedure does not exist in the configuration database. 


The error does not affect the functionality of the product in any way and can be safely ignored. To resolve this issue, install Service Pack 2 (SP2) for your SharePoint 2010 product. For more information about SP2 for SharePoint 2010 products, click the following article numbers to view the articles in the Microsoft Knowledge Base:
2687453 Description of SharePoint Server 2010 SP2
2687464 Description of SharePoint Foundation 2010 SP2

More Information

The database stored procedure proc_UpdateStatisticsNVP is part of the SharePoint content databases and is called to update the index statistics for the "NameValuePair" database tables. The "NameValuePair" tables exist only in the SharePoint content databases. Other SharePoint databases do not have the "NameValuePair" database tables. This includes the configuration database. Because the "NameValuePair" tables do not exist in these databases, proc_UpdateStatisticsNVP is not needed on these databases.