Event ID 17055 Event Message "Invalid object name 'dbo.GroomLock'" When the Microsoft SQL Server Service Starts


You may receive the following event message in the Windows application event log on the computer that is running Microsoft SQL Server:


This problem occurs because the Microsoft SQL stored procedure MOMGroomCoordinationReset points to the GroomLock table in the OnePoint database, but it does not point to the OnePoint database to access the table. As a result, the stored procedure tries to access the GroomLock table in the Master database instead of the OnePoint database.


To work around this problem, manually change the stored procedure to point to the OnePoint database. To do this, follow these steps:
  1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
  2. Type:
    ALTER PROCEDURE MOMGroomCoordinationReset AS
    declare @ErrMsg varchar(255)

    UPDATE OnePoint.[dbo].[GroomLock]
    SET [isGrooming]= 0, [LastGroomStarted] = NULL

    if @@error<>0 goto Err
    return 0

    SELECT @ErrMsg = @ErrMsg + ' --SQL Server error ' + convert( varchar(20), @@error ) + 'encountered in MOMGroomCoordinationReset'
    RAISERROR (@ErrMsg, 16, 1)
    return 1
  3. On the Query menu, click Execute.


Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

ID do Artigo: 826373 - Última Revisão: 8 de set de 2008 - Revisão: 1