Event 5586 after applying SP1 to SharePoint 2010

Posted: 12th August 2011 by Seth Killey in SharePoint

Some more carnage from the SP1 update.  You may get the following:

Unknown SQL Exception 2812 occurred. Additional error information from SQL Server is included below.

Could not find stored procedure ‘proc_UpdateStatisticsNVP’.

The reason for this is there is a stored procedure called proc_UpdateStatistics which references proc_UpdateStatisticsNVP, however SP1 fails to create the later stored procedure in all databases.  This website provides a nice script to identify all databases missing the stored procedure.  Download script to check for missing stored procedure

Now that you know which databases are missing this stored procedure, use the link below to download a script to create the stored procedure.  Just make sure to select the appropriate database from the drop down in SQL or type USE [databasename] GO at the beginning of the script
CREATE_proc_UpdateStatisticsNVP

  1. Steve Shockley says:

    FYI, your blog software changes normal single and double quotes into “fancy” quotes, making copy/paste of the exec command above difficult.

  2. Seth says:

    thanks Steve…updated with a link to download the script

  3. winner winner chicken dinner says:

    Very nice… thank you!

  4. Karel says:

    Nice… thank you!
    again, something new, something I didn’t know, and it is resolved.Thanks!
    Karel

  5. Johnny says:

    Thank you. Happiness is a clean Event log. Well, it is cleaner anyway.

  6. Christine says:

    Awesome! Thank you!

  7. Jing Tu says:

    How do I run your script on the SharePoint server? Thanks! Jing

  8. Seth says:

    It’s not run on the SharePoint server per se. You run the script on your SQL Server database which may be on the same server as SharePoint or a different server altogether. If you don’t have it installed on your workstation already, install SQL Server management studio (free) and connect to the SharePoint database server.

  9. nova says:

    Thank you very much for the scripts!

  10. Rexican says:

    wow…. I wish i found this sooner.. Thanks for the post. It worked like a charm.