umanpowered (12/3/2008)

---

I was thinking there would be a "last update" column on some type of data-table, from what I gathered from what Grant was explaining, that I could use...

No idea. Can you please post the information I asked for.

The latest error log (the one that was started after you restarted the server...

Adhoc fulls don't render...

If the showplans aren't on, where does this come from?

StmtText

----------------------------------------------------------------------------------------------------------------------------------------------

select a.rut_empleado

from ANTECEDENTE_CONTRACTUAL a

WHERE exists(select 1 from CENTRO_COSTO x

...

ScottPletcher (12/3/2008)

---

That's not practical in this type of situation.

If the log is already bloated because it previously wasn't...

Are the two files that SQL's looking for there?

And the error log after SQL restarted?

Are there any IO-related errors in the windows event log?

Can you check the versions that I asked about above?

And the error log from after the restart? When the DB went into recovery?

Does the G drive still exist? Can you see it, can you read files on it?

SQL's looking...

Do you have showplan_all or showplan_text on?

That option means the query won't get executed, just parsed and optimised. The query's not actually running, so there's no stats output.

You've got disk problems.

It's a text file...

Can you please post the contents of your error log? (it's a file just called errorlog, text file)

An 823 error is a hard IO error. It means SQL requested an...

Can you do a maint plan to backup to disk (not to a backup device)?

Did you turn statistics io on?

Are there rows in both of those tables?

Please run SELECT @@version on the server and post the results. Please go to the help menu in management studio, select About Management studio and copy the version listed there...

umanpowered (12/3/2008)

---

If I'm understanding SQL 2005 DBMS correctly, the DBMS "engine" has some impact on the the underlying system tables. Maybe I'm way off base here, so I apologize...