I recall back in my engineering school days we always used 365.25 to account for leap year.

SQLOzzie

So here are my final scripts, since no one seems to ever post the 'final' result
SQL Agent Jobs where you are not configured to receive email

Ok - Playing around I can see that 

SELECT *
FROM msdb.dbo.sysalerts
WHERE has_Notification = 0
lists all of the alerts with no coverage. What is the JOIN to...

TY.

Phil,

What utility do you use to get those cool cutouts of the SQL code?

Great article - I stole a few chunks for my own data dictionary.

Not a single response?

Wouldn't that work in 2400 - not 4000? Divisible by 4 but not 400?

Luis,

That was exactly what I needed. Once I completed the second SQL - I was good to go. I guess when I had tried that technique myself I had implemented...

Phil,

Are you referring to a task like the one described here?

http://stackoverflow.com/questions/19521920/ssis-data-transformation-rows-to-COLUMNS

Thanks for the assist,

Doug

Well, every time I hit Column7 with a value of S, I know I have a row. This was a simplification of the data - I do have an AccountID.

What...

I've had the same error generating a massive execution plan - so intellisense would tie in.

The client is still 32 bit?

Doug

Thanks Gail, I'll give it a go.

Best,

Doug

Great article.

Aligns perfectly with your SQL Saturday Presentation 2 days ago - awesome contributions to the cause!

Doug

Guys,

Those were great suggestions.

I solved it in a different way - which I will post - thanks for all of examples.

We are on 2008R ourselves, we are hopefully going right...