Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Tampa Florida
    Posts
    3

    Angry Unanswered: Integrity Checks - failed Weekly Maintenance Plan

    I encountered a problem with the maintenance plan that I built a couple of months back. This job was working fine until yesterday, but I am receiving the following error messages when I ran the Integrity Checks. Daily backups are running fine so far.

    Error 207: Invalid Column name 'category_id'
    Invalid column name 'netsend_address'
    Invalid column name 'last_netsend_date'
    Invalid column name 'last netsend_time'

    By the way, I am not able to open or edit my job either because I received the same error. I rebuilt the same job from scratch three times without any success. Would you mind to help me out with this problem?

    Operating system: Win 2000
    Database: SQL server 2000 with Services Pack 3

    I really appreciate any comment or suggestion.
    Thanks,

  2. #2
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    So this is a SQL Server 2000 job that's giving this error? Is this job ActiveX? You may have better luck posting in the SQL Server forum here...
    That which does not kill me postpones the inevitable.

  3. #3
    Join Date
    Feb 2004
    Location
    Tampa Florida
    Posts
    3

    Integrity Checks - failed Weekly Maintenance Plan

    Yes, this is a SQL Server 2000 job that's giving this error?
    I used the Wizard tool when I created this maintenance plan. I believe this is a job active x too. My job is scheduled to run once a week.

    Please help!

    Thanks,

    Mery

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •