It should be possible, but I don't know enough about Java to know how. Perhaps ask that on a java forum?

Just to clarify. Temp tables and table variables are...

I don't think that dropping the keys is going to get rid of all the messages. Some, maybe.

As well as foreign keys with missing key column info (which dropping the...

And what's the version of your client tools? Help - about management studio.

Mike Levan (12/3/2008)

---

In general what wud be the reason behind the few db's going into recovery state every time after restarting the server though i dont have any pending trasaction...

Is that error log you just posted from the same system that had the 823 errors? It doesn't appear to be so, the database names are different.

Is the system that...

Have you checked the system event log for hardware-related errors?

The other question to ask is why dynamic SQL?

Please post the latest SQL error log. The one after the latest reboot.

Have you checked the system event log for hardware-related errors?

Replication can work in simple recovery. It's mirroring and log shipping that require full only (for mirroring) or full or bulk-logged (I think for log shipping). I seem to recall...

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...