DBCC inconsistency

We have a very minor problem with a db. It's not
affecting how the db runs, but it's causing BackupExec to
show red for the server every time it back up. Here is
the error.
Consistency checking magic
Consistency Check including Indexes.
There was a problem running the DBCC.
^ ^ ^ ^ ^
SQL Server returned the following error message:
Table Corrupt: Object ID 2042490355 (object '2042490355')
does not match between 'SYSCOMMENTS' and 'SYSOBJECTS'.
^ ^ ^ ^ ^
I'm told that I just need to reconcile this
object "2042490355" in those two db's using a simple sql
script. Can anyone tell me what that script is or where
to find the article for what I need? I've been searching
support for at least an hour.Shannon
Who told you just needed to reconcile this object in the two dbs? I have no
idea what someone might mean by 'reconcile' without knowing what the problem
is.
First of all, we're most likely talking about just ONE database, but there
are two system tables involved.
Sysobjects has one row for each object in the entire database, and
syscomments contains the textual definition for any objects with a TSQL code
definition such as stored procedures, functions, constraints, views, etc.
So make sure you are in the right database.
Then see what object the message is referring to:
SELECT object_name(2042490355)
Then run sp_helptext 'whatever that object name was'
You might try just dropping the object, and recreating it, but save the
definition before you do that.
Since the object is not a table (or so it seems from this evidence), you
don't have to worry about losing data.
Good luck
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Shannon" <srubin@.pec.com> wrote in message
news:006a01c3602a$482282a0$a401280a@.phx.gbl...
> We have a very minor problem with a db. It's not
> affecting how the db runs, but it's causing BackupExec to
> show red for the server every time it back up. Here is
> the error.
> Consistency checking magic
> Consistency Check including Indexes.
> There was a problem running the DBCC.
> ^ ^ ^ ^ ^
> SQL Server returned the following error message:
> Table Corrupt: Object ID 2042490355 (object '2042490355')
> does not match between 'SYSCOMMENTS' and 'SYSOBJECTS'.
>
> ^ ^ ^ ^ ^
> I'm told that I just need to reconcile this
> object "2042490355" in those two db's using a simple sql
> script. Can anyone tell me what that script is or where
> to find the article for what I need? I've been searching
> support for at least an hour.