Thanks Paul I will definitely explore that option. I have a monitoring system for failed jobs so it sounds like I would at least be notied that something is amiss....

Will a job with the following fail if corruption exists? Or will the job succeed?

DBCC CHECKDB(N'master') WITH NO_INFOMSGS

I'm suddenly feeling a bit exposed since I am not sure if...

Yes, something always does go wrong.

This particular business process is an intermediate step. If the primary business group doesn't generate the record the next business group in line can't...

Thanks all. This gives me several ways to approach the problem.

Obsolete objects is such a huge issue. Is it technically feasible to track the last time any object was used or would the overhead of doing so be just too...

I think what you are doing is completely reasonable, you can certainly insert your relevant statistics into a table and email them yourself. I didn't meant to overwhelm you, just...

The sessions I create and initialize every time the procedure runs. It facilitates logging if you want to record the history of the process.

I do tend to do this...

If its more of an import status/validation I would go for the suggestion above by foxxo to use sp_send_dbmail.

Generally I use this pattern within a stored procedure.

-create an entry in...

I wish there was a 'retract my post function'....

How embarassing! Sorry to be a nuisance.

Excellent, I understand the code and the role of the the tally table. Thanks.

Thanks Jeff, when I don't understand the code I prefer that it performs well and is concise.

txtPost_CommentEmoticon(':-)');

Thank you all again. I had never used a tally table.

Please allow me to ask a question which will clearly demonstrate I am still trying to understand the solution.

What's the...

Sorry to answer my own question. I really did google this and I read the first 5 pages. On the sixth page I found

WHERE MyDate = DATEADD(dd, -DAY(DATEADD(m,1,MyDate)), DATEADD(m,1,MyDate))

Thanks all. I'll pursue the role based approach.