DBCC CHECKDB does NOT fail when run against tempdb.

The answer is No, as the explanation describes, yet if you answer no it is incorrect?

How can this be?

Is there some secret I am missing here?

I have a routine the regularly defragments the indexes.

My understanding was that a clustered index represents the physical order of the records in the database, and that on inserts if...

Thanks to all.

Good points!

The table has no updates, but periodically there are deletes, but the deletes are based on various criteria.

The bigint column is not used as a reference to...

that's the solution . . . it was a linefeed character not a space.

Thanks,

Bill

I have tried stopping and starting the sql agent.

And I have also tried scripting the jobs, and found them all to be just fine.

We've decided that we are just going to run the steps manually until such time as we can take the server down and re-install.

I've run out of ideas of things...

Already done,

I think something is seriously hosed on the server.

all the components of the jobs (at least the TSQL based steps) have all been successfully tested in the appropriate databases.

The "Run as" is blank on everything

the sa account owns all the jobs

It's running under the local service account not a domain account.

The Domain Admins are still in the Administrators account.

Actually all of the joins are matched by type, so it is not caused by that.

I just figured out the problem.

the HandleID is actually a nvarchar column rather than an...

It must be something bizarre like that.

I just selected the max(recid) from the table, and it is still in the int range . . . so the error must be...

I'll buy that there is something else at play.

but no nvarchar columns are even addressed in the query.

Why it fails converting an nvarchar to an int is my big question.

I...

I have to run the query against a join of two base tables.

The Datetimex, RecID and ID columns are in one table, the HandleID in another.

The tables are joined on...