I got this annoying error:

Log Name:      Application
Source:        Microsoft-SharePoint Products-SharePoint Foundation
Date:          8/19/2011 12:00:16 AM
Event ID:      5586
Task Category: Database
Level:         Error
Keywords:     
User:          TSLAN\spfarm
Computer:      TS-PDC.tslan.local
Description:
Unknown SQL Exception 2812 occurred. Additional error information from SQL Server is included below.

Could not find stored procedure 'proc_UpdateStatisticsNVP'.

It turns out proc_UpdateStatisticsNVP was missing from some of SharePoint databases. To access SharePoint database on the local machine as in SBS 2011 server. You can try to connect as .\SharePoint. You might need to enable administrator which is disabled by default in SBS2011.

After you have connected to it, you can use this very useful script which I found from http://blog.ray1.net/2011/07/could-not-find-stored-procedure.html.

exec sp_msforeachdb 'if exists(select name from [?].sys.objects where type = ''P'' and name like ''%proc_UpdateStatistics%'') AND not exists(select name from [?].sys.objects where type = ''P'' and name like ''%proc_UpdateStatisticsNVP%'') select ''?'''

You will find the databases which misses the proc_UpdateStatisticsNVP storeprocedure then you can use the script below to find an existing proc_UpdateStatisticsNVP and recreate the store procedure in those database with missing proc_UpdateStatisticsNVP.

exec sp_msforeachdb 'if exists(select name from [?].sys.objects where type = ''P'' and name like ''%proc_UpdateStatisticsNVP%'') select ''?'''