Thanks, Grant.
We have logged it. Was chancing my arm in case someone else had seen something similar or had any tips. Never waste a good crisis, I say.

Thanks for sharing this, your article is well written and very easy to follow as is the output of the sproc. Any tool that can join the toolbox of a...

Enclose your exec statment in brackets like:

exec (@SqlString)

Agree with the fourth statement, it's the only one that returns a correct value.

Ah, forgot to say that no checkpoints were issued even despite the fact that DBCC OPENTRAN said there were no open transactions in the db.

We had a similar problem with a database. The transaction log would grow and grow and it wouldn't get truncated. No checkpoints were issued by sql at all (according to...