Viewing 15 posts - 541 through 555 (of 1,319 total)
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.
-- You can't be late until you show up.
August 3, 2009 at 8:35 am
What service pack are you running? Should be on sp4 to correct this bug.
LMGTFY:
-- You can't be late until you show up.
July 31, 2009 at 9:23 am
RBarryYoung (7/29/2009)
Greg Edwards (7/23/2009)
RBarryYoung (7/23/2009)
. (7/22/2009)
I obviously missed out on SO much by being born too soon.Ph'nglui mglw'nafh C'thulhu R'lyeh wgah'nagl fhtagn
Well yeah. There really wasn't much to do...
-- You can't be late until you show up.
July 30, 2009 at 6:14 am
Jack Corbett (7/29/2009)
Anyone else want to tell this guy NOT to shrink his databases?
I chimed in as well.......:-D
-- You can't be late until you show up.
July 29, 2009 at 11:45 am
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),...
-- You can't be late until you show up.
July 29, 2009 at 11:45 am
Roy Ernest (7/27/2009)
-- You can't be late until you show up.
July 27, 2009 at 11:46 am
Roy Ernest (7/27/2009)
Or join forces with someone and do a session just to clear them of their Road blocks if they have any..🙂
I'll bet if you pay expenses you'll...
-- You can't be late until you show up.
July 27, 2009 at 11:21 am
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...
-- You can't be late until you show up.
July 23, 2009 at 9:06 am
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...
-- You can't be late until you show up.
July 23, 2009 at 7:40 am
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...
-- You can't be late until you show up.
July 23, 2009 at 6:59 am
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.
-- You can't be late until you show up.
July 22, 2009 at 2:49 pm
Greg Edwards (7/21/2009)
Grant Fritchey (7/21/2009)
Yeah, I'd pay postage on stuff you want to get rid of as well. Post the list. We'll make claims.
I like Alvin's idea that the recipient...
-- You can't be late until you show up.
July 21, 2009 at 1:06 pm
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...
-- You can't be late until you show up.
July 21, 2009 at 12:10 pm
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...
-- You can't be late until you show up.
July 21, 2009 at 12:00 pm
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...
-- You can't be late until you show up.
July 20, 2009 at 7:09 am
Viewing 15 posts - 541 through 555 (of 1,319 total)