Thanks from me aswell.

Phil.

Or you can have a job to "ALTER DATABASE MSDb SET RECOVERY FULL" using the MS supplied schedule  "Start automatically when SQL Server Agent starts", which is what I have done.

Define second job step to...

I use the MSDb for information about the latest db / transaction log backups on all databases (as does Enterprise Manager).

Ed. Thanks for your comments.

What about building the SQL statement at run-time and using EXEC (@Sql).

Thanks Jeremy

Phil.

No replies yet!!

Basically what I am asking is does DBCC CHECKDB return an @@ERROR value <> 0 if it reports errors, or is it necessary to scan the output text...