Bristolred (12/3/2008)

---

I now realise that this is not the case, as I’ve found out that the log is truncated every time it is backed up. So I don’t understand where...

If the triggers are on the same event, why not just have one trigger that does the work of both?

Just check the version of that management studio, make sure that the patch did successfully patch the client tools.

This particular one's usually the result of...

So where did you set the maintenance plan up from?

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