none
Unable to find store procedures

    Question

  • Hi SharePointers

    I need some assistants with an issue which has been going on for sometime.

    I have two errors in the event viewer on one of our applications servers

    Error One

    A database error occurred. Source: Microsoft SQL Server Native Client 10.0 Code: 2812 occurred 1 time(s) Description: Could not find stored procedure 'dbo.proc_MSS_Crawl'.

    (I've check the database and this store procedure doen't exist)

    Error Two

    A database error occurred. Source: Microsoft SQL Server Native Client 10.0 Code: 2812 occurred 1 time(s) Description: Could not find stored procedure 'dbo.proc_MSS_CrawlAdmin'.

    This procedure is visable

    Please help

    Regards

    
    Tuesday, January 8, 2013 12:03 PM

All replies

  • Well that one takes me back... As I recall that proc caused no end of issues in MOSS. I take it at some point in time you did an I place upgrade? Do you have the luxury of being able to just drop and recreate your search service in 2010?

    ieDaddy
    Blog: http://iedaddy.com
    Twit: @iedaddy

    Wednesday, January 9, 2013 1:15 AM
  • Hi ieDaddy,

    I do indeed have the luxury but I'm a novice in area of SharePoint i.e adding/removing services.

    Do you have any documentation to?

    What would be the impact or recreating the search service?

    Regards

    Thursday, January 10, 2013 11:29 AM