Peter2012 (1/14/2015)

When I tried to run the same script on my other database, it's throwing below errors. The same exact script, no change at all.

Msg 245, Level 16, State 1,...

Peter2012 (1/14/2015)

Have some queries:

- How to add date and timestamp to the message?

- What does it mean when the status is showing GOOD or otherwise?

- Should the script be run...

EDIT: The post removes the < br /> tag that I added...so you need to put that back into the code...

I believe it's a rendering issue; but easily fixed....

Curious, have you altered the original script? Are you getting the results as an attachment or as the embedded HTML?

EXECUTE msdb.dbo.sp_send_dbmail @recipients = @Recipients

,@subject = @Subject

,@body = @Body

,@body_format...

+1 Alexander Suprun

I temporarily resolved the issue by backing up the old stored procedure under a new name and then recreating it under the original name. The report now runs as normal...

I've seen this happen with a lot of temp tables (and for the life of me I can't recall the exact reason for its cause); but try replacing some of...

What does the result of this show for this exact report (you may need to tweak the query to tailor to your needs)? SELECT TOP 1000 STATUS,

...

Did you ever end up using this software solution? I know this is a very old thread but noticed you were online so thought I'd take a chance...

We're looking...

Thanks guys, I wasn't aware of these trace flags. I read the article and do have some concerns that Trace flag 1117 will cause all files to grow equally...

This is more for a case when there are multiple data files in TempDB and I don't wish to set autogrowth because I don't want to risk growing a single...

It's a feature!

+1 to what everyone else has echoed - great question, and unfortunately, one I missed - TGIF!

Thanks Perry - I will read through this - thanks for sharing it

Russell; I'm looking to implement something similar to this and I'd be very curious to see how you implement this (seems like a great step-by-step article that you could post...