Thanks for catching that! :w00t:

Try:

dbo.spShowJobRunSnapshot '9/16/2012', '9/16/2012 23:59'

Yes I did. With so many servers it became a requirement on all new server builds. It was a small part of a SQL monitoring system.

It was setup...

I think there is a bit of confusion between Shrink Database and Shrink Files.

Shrink Database reorganizes the tables, indexes et al., and is VERY BAD for organization as well as...

Of course let's not forget that the questions were numbered 1-7  So there really wasn't a right answer...

1. ALTER TABLE HumanResources.Employee DISABLE TRIGGER...

If a felon is someone who commits a felony is an iron someone who commits irony?

That would make God an iron...

Or better yet, how come a figure of speech is a:

'figure of speech' ?