While I agree with Gift's assessment of service packs, I've never had an issue restoring from sp4 to sp3. It's still sql 2000 so you shouldn't have any issues.

What service pack are you running? Should be on sp4 to correct this bug.

LMGTFY:

http://tinyurl.com/n4fu76

RBarryYoung (7/29/2009)

---

Greg Edwards (7/23/2009)

---

RBarryYoung (7/23/2009)

---

Well yeah. There really wasn't much to do...

I chimed in as well.......:-D

One caveat - I did not read all of Jack's previous links - BUT wanted to add, shrinking the DB and/or logs, when they auto-grow (if the setting is enabled),...

Roy Ernest (7/27/2009)

---

Yes, I agree with you. I think we might have a corporate sponsor soon. I will know for sure in a month. 🙂 If that works out, I...

I'll bet if you pay expenses you'll...

Go to BOL, check out xp_sendmail.

Blurb from BOL:

Remarks

The SQL Mail session must be started prior to executing xp_sendmail. Sessions can be started either automatically or with xp_startmail. For more...

I really don't use it for success or failures but something like this should work:

CREATE PROCEDURE [dbo].[On_Success]

EXEC MASTER.dbo.xp_sendmail

@recipients = rogerabram@gmail.com

@subject = 'Backup was successful',

@message = 'Backup was successful'

go

Then in...

There is a stored procedure called xp_sendmail (see BOL) that I use all the time. Wrap it into a stored proc and then send on success. Personally, I would send...

Did a "certain" antagonistic, twitter-impaired poster get whacked again? I was reading a bit of some offensive rubbish yesterday which seems to have been removed.

Greg Edwards (7/21/2009)

---

I like Alvin's idea that the recipient...

Whatever DVDs/boxed sets that you have that Lynn doesn't want, send my way. I'll even pay the postage! Just to help free up some space of course 😛

Edit - See...

I've been here for quite some time and have never received spam because of my association with the site. Before you slam the community, be sure it's SSC. Somehow, I...

Just curious, is anyone receiving emails from this thread? I haven't received any all weekend but new replies have obviously been added - nothing being filtered on my end that...