Forum Replies Created

Viewing 15 posts - 481 through 495 (of 507 total)

  • RE: SQL 2000 and Setting up SQL Mail

    Oh no problem. I'm all about sharing info. We mirrored the port our exchange server is on taking a complete log of all traffic to send to MS for further...

  • RE: SQL 2000 and Setting up SQL Mail

    Well.... There have been a couple of developments today. One, Our exchange servers blew up. During the maint window last night the ip's of all the servers changed and we...

  • RE: SQL 2000 and Setting up SQL Mail

    sqlserver and sqlserveragent are using the same domain account. One server started sending mail last night after a scheduled reboot. But the others arn't. They are all setup the same...

  • RE: SQL 2000 and Setting up SQL Mail

    yep the same. The account is also a local admin and domain admin.

  • RE: SQL 2000 and Setting up SQL Mail

    The job scheduler does work and send mail. xp_sendmail doesn't and you can set the option for a backup job to send you a report:

    The attached report is a summary...

  • RE: @@ROWCOUNT problem

    no you don't have to disconnect the record set to pull a row count. you do have to setup the recordset to pull the right count though.

    **

    objrec.cursorlocation = 3 'set...

  • RE: SQL 2000 and Setting up SQL Mail

    lol. If I could get away with it I would but I sit right next to our Sr. admin he'd kill me.

  • RE: SQL 2000 and Setting up SQL Mail

    Did that.... Did it last time around and again after the sp1 patch. Any other ideas?

    🙂

    Wes

  • RE: SQL 2000 and Setting up SQL Mail

    Ok. I reinstalled the test sql box. Setup outlook2k using a agent domain login it is a domain admin it has a mailbox I can send and recive mail with...

  • RE: SQL 2000 and Setting up SQL Mail

    Ok, I can send and recive mail from the outlook client. I stopped and restarted the services I attempted to send mail via xp_sendmail and get this

    Server: Msg 18025, Level...

  • RE: SQL 2000 and Setting up SQL Mail

    Ok here we go again. After applying sp1 to the test server it sends mail fine. I applied sp1 to three servers last night all of them configured the same...

  • RE: moving server locations with NO down time

    I've got a 60 second dns rollover window to apply the last update to the temp servers. So, I guess NO down time is a misnomer but less than one...

  • RE: @@ROWCOUNT problem

    I had a similar problem with a very busy web app and ended up putting all of those kinds of functions that needed return row counts into sprocs to keep...

  • RE: sql backup and restore

    I use asp to kick off a stored proc to do the restores just pass the variables from the asp page to the sproc and kick it off.

  • RE: backup software or methods

    I currently use sql backup to backup to ether directly to the file server or to the local disk. All backups are held on disk for a week. I've got...

Viewing 15 posts - 481 through 495 (of 507 total)