Post reply

Issue with Optimization step in SQL Server

  • March 31, 2009 at 1:03 pm

    #207929

    Hi,

    I setup a maintenance plan on SQL2000 (SP4) server. Optimization step

    failed on msdb database with the following error:

    Could not find a table or object named '[dbo].[RTblPropDefs]'. Check

    sysobjects.

    Could not find a table or object named '[dbo].[RTblRelshipProps]'.

    Check sysobjects.

    I confirm that both objects exist in MSDB database.

    Why would optimization step reports that those objects are missing if

    they are on that database?

    How would I solve this error?

    I get similar error message on one of the user databases on SQL 2005

    SP2.

    Thank you,

    T.

  • March 31, 2009 at 6:08 pm

    #969567

    Check-->http://support.microsoft.com/default.aspx/kb/288745

    HTH!

    MJ

  • April 1, 2009 at 6:52 am

    #969784

    That really doesn't work for me since running DBCC Checkdb doesn't produce any errors. It only happens when optimizatoin runs and trying to rebuild indexes.

    T.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply