Probably not. What errors are you getting when trying to select from the tables?

If it were a corrupt DB, there might be a chance or reading the pages raw and...

Go into the job step and set it to log output to a text file (I don't remember where this is in SQL 2000)

With that, you'll see the full output...

Is that on SQL 2000 or SQL 2005?

What's the state of the database? (suspect, recovering, offline, ...?)

There may be a way, but just so that you can copy the data...

How do you know the server's slowed down?

More CPU usage?

Queries in general slower?

Some queries slower?

Something else?

Depends. What help do you want?

Which of the ITP exams are you taking for which of the certifications?

When the exact code of the view and the exact code of the trigger appear, I'll help you. Until then, you're wasting my time.

So that we're on the same page, what are you thinking about when you say short-circuit?

What C++ (and other C-like languages have) where it the first expression in a condition...

A few comments on your comments.

imho, the use of CheckDB isn't to fix corruption errors, it's to detect...

The view as you've written it will select from a table in the same database as it is created. To select from a table in a different database, it should...

Can you please post the code? You can change the table and column names if needed. It's hard to debug from descriptions

Is the history table in the DB with the...

Select * from ..... ????

And the trigger?

Consdering that Steve is an experienced DBA, I'd say the site's DBs are in good hands.

Can you post the text of the view and the trigger please?

SQL 2000 or SQL 2005?

If you have a SQL 2005 server around (even if its just a desktop) try out the RESTORE DATABASE ... WITH CONTINUE_AFTER_ERROR

It's new...

I would say that a good/great programmer is never content with 'good enough' but always wants to do the best job possible.

A good/great programer is always learning. Reading technical books/blogs/white...