I can't imagine why he thinks it would need to be restarted, for a simple job change like that

Here's an article by Paul Randal on recovering a suspect database, it includes steps on how to force a database into suspect mode:

http://www.sqlskills.com/blogs/paul/post/TechEd-Demo-Creating-detaching-re-attaching-and-fixing-a-suspect-database.aspx

Thanks Gail.

Jack, thanks for the mammoth query!

The server was last rebooted a couple of weeks ago (funnily enough when the same process caused the tempdb logfile to grow out of...

Thanks Jack

It's a 3rd party application that runs this query, and we think this process was the one that caused tempdb to grow to 50GB all of a sudden, so...

Thanks Brandie

I've been running a trace since 10am, they are running a process that they think might be what caused the rapid expansion last time

I am also in conversation with...

Thanks again GSquared, good to have the reassurance!

Thanks GSquared, exactly the answer I was expecting!

Heh, how often does that happen...?!

We currently do nightly full backups and tranlog backups as our standard server set-up for all sql servers...

Thanks Paul

There are a lot of PRINT statements within cursor loops, and all over the place generally - and there is certainly no @debug flag.

Also SET NOCOUNT ON is...

Thanks again!

Thank you!

I understand why SET NOCOUNT ON not being in the SP could be problematic with the potential extra data travelling down the wire, but was unsure whether PRINT could...

does that return the checksum of a new cat?

I pictured Jens Lehmann when I first read it, although have since seen he has an extra "n" in his name

(he's a soccer goalkeeper famous for shouting a lot and...

Cool, thank you both!

Somewhat off-topic (to the topic that is currently off-topic, that is):

IIRC someone who frequents the Thread writes fiction - have I imagined this? Any pointers as to who it might...

I would have gone to the Saturday one, but I have tickets to Motorhead on the Friday night in Leeds, and hence wouldn't be able to get to the event...