I got this right for the wrong reason. I didn't know that the lack of the GO was what added the second insert to the stored procedure. But the test...

Steve Jones - Editor (11/6/2008)

---

If you're having issues, then you might need to apply the SP. If not, I'd hold off. Typically when I've called MS in the past, they...

Hello Steve,

Do you recommend waiting for SP3 for SQL 2005 or applying the cumulative update package...

Don Preston (10/31/2008)

---

I've spent my entire life in Detroit and from the time I was a kid in the 1960s, the night before Halloween was called Devil's Night. ...

What was Devil's Night?

Yes! I got a question right!

Funny how "Shooting off fireworks" is getting 3% at the moment. 🙂

Sorry - need to update this post to say:

Happy Halloween, everybody!

Thanks for all the pointers - I'll take a look and report back soon.

webrunner

Great, thanks so much for your help!

My newly created maintenance plans, which I based only on the job email settings, now work correctly. But thanks for the additional information on...

I may have found out what was happening here.

When one creates a Maintenance Plan using the Maintenance Plan Wizard, one of the last screens gives an option (checkbox) for whether...

bc (10/6/2008)

---

i had a hard time coming up with false answers that would throw the reader off. i thought some might misread 50000 for 500000, and thus 150000 (50000+50000+50000)....

Thanks, neat question.

I'm sure this may not work every time, but I used the process of elimination based on the sums provided as answers.

I first assumed that there was no...

The above suggestions (especially finding what is using the space and monitoring growth) are excellent places to start.

Also, check to make sure there are not extra copies of service...

GSquared (9/22/2008)

---

Once you switch to 90, you can't switch back to 80, except by restoring from a backup taken before the switch. (Which means, of course, that you'd lose...

GilaMonster (9/21/2008)

---

YSLGuru (9/21/2008)

---

When a database with a compatability level of 8 is running on SQL Server 2005 is it truely a database thathas beeen upgraded to SQL Server 2005 or...

Excellent, thanks,

webrunner