Post reply

Database Maintenance/Optimizations - Error 21268

  • February 3, 2006 at 4:20 am

    #116133

    SQL Server 2000 on Win2003

    Database Maintenance/Optimizations generates the following error in the log:

    Error 21268: [SQL-DMO]Row or column specified is outside the range of the

    specified query result set.

    Which "specified query result test" is this message speaking about?

    And what can I do to repair the DB?

    Many thanks for your help,

    Dan

  • February 3, 2006 at 8:26 am

    #618693

    This message generally comes when  maintenance planID is not correct.

    Correct the plan ID for that maintenance plan and then check, it should work.

    You can get plain id from msdb, sysdbmaintplan_databases which has  one row for each database.

    If this doesn't work remove maint. plan and rewrite, which will correct this id issue.

    Hope this helps 

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • February 8, 2006 at 12:45 pm

    #619618

    Many thanks Sameer, I wrote a new plan and it worked 

  • November 9, 2008 at 2:04 pm

    #896080

    hello, thanks for your post re same error:"Error 21268 [SQL-DMO]Row or column specified is outside the range of the specified query results set" , so I run " select * from sysdbmaintplan_databases" in sql 2005, result is empty, nothing in this table. I wonder if it is the reason when I run system db backup by using main plan wizard, still got same error. I just switch sql 2000 to sql 2005.

    many thanks,

  • December 18, 2008 at 2:22 pm

    #914874

    Hi Sameer,

    I too have the same issue. We have a maitenance plan which runs on every weekend and failed with the same above error. As you posted, I have re-created the Maint.Plan, but the issue didn't solved. I checked with the Plan ID in MSDB but could not figure out where to correct the plan ID.

    Please suggest. I need to resolve this by this weekend.

    Kiran

  • March 6, 2009 at 6:41 am

    #954826

    Thanks Sameer. It was an old posting but still helpful. Paul

Viewing 6 posts - 1 through 5 (of 5 total)

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