LOL, nice reference, Grant. Grant's book is pretty good, as is the one he wrote on Execution Plans.

Don't see it on the McGraw Hill site either. My guess is that it's been delayed. I'd email the publisher.

You have two choices. One is enable email notification on completion of the job. This is changing the job, but not the command, just adding the notification.

The other is that...

Thanks for the repeat of the info, as I actually missed a touch there when I read through things.

Try not to get too defensive as many DBAs hear this question...

How does the .NET code connect? the login used, an the user mapped to it, need permissions to the proc.

a GRANT EXECUTE ON (proc) to XXX will work, but...

So you want to use dateadd to move your date to yesterday. Then if it needs to be 3pm, you need to do some casting. You will need to get...

I'd still do system backups. It isn't a catastrophic failure that's an issue. What if part of msdb becomes corrupt? Or someone removes a login/job/whatever? You don't want a VM...

I'm late, but I always have done daily master, msdb, model. Things rarely change, but they always seem to have changed right before something breaks. They're small, no reason not...

Lynn, I think it was a complement.

Bandwidth (video call sucks today)

You might read this http://msdn.microsoft.com/en-us/library/cc966540.aspx

In terms of the CPU, 100% isn't bad. The server uses all resources to work on queries when it needs them. If it's sustained, then you...

saw that, he's joining the broadcast team.

Thanks, good to get feedback. Pass them along to your friends!

OK, OK, some funny replies in here. The question was badly worded but let's not scare someone away from posting. I'm sure there is a valid question in here if...

Let us know. I was going to post what Lynn did, but too slow. I think that's the best way to do it.