Do you have the luxury of renaming the two new machines, and their IP address to the same as the originals? Thats what I've done in the past and had...

Not in native SQl 2000 or SQL 7. See the prior posts for the solutions for these platforms. Also, if you have a solution, please state it. Simply writing "there...

I think (and it's been awhile since I've used it and I don't have any samples here) you need to run the query, sending the results to a text file...

Actually it was under "more comprehensive example". Plus, you're supplied with the entire lsit of parms for the stored proc in the article. Sometimes the simplest solutions are the easiest...

I believe you're missing the smtp server specification -

@server = N'mail.mydomain.com'

If I remember correctly, you download it and create before you can use it. I'm also on S2KSP4 and I don't see it.

-- edit - Beaten by 2 seconds. 😛

Yes but with serveral hundreds jobs already in place, all using Outlook, I can't justify the time spent, although, reading what I just wrote, we could save a license fee...

Jack Corbett (8/5/2008)

---

At my last job we used XP_SMTP_SENDMAIL (http://sqldev.net/xp/xpsmtp.htm) on all our SQL 7 and 2000 servers so we could get away from SQL Mail except for alerts and...

Glad I could offer some assistance. Just a quick side note, my servers are all Windows 2003 and Outlook 2003.

edit - Also, at my last job we used SMTPMail. It...

This is what I do within a SQL Agent Job Step, works every time.

DECLARE @query varchar(1000)

BEGIN

EXEC master.dbo.xp_sendmail @recipients='myname@mycompany.com',

@message='The attached text file contains a list of active employees.',

@query= 'select CompanyId as...

Denby (8/1/2008)

---

ok i just did what u said setting autoclose on, looking at the log i noticed a lot of "starting up database dbname" would this indicate that users or...

California (7/24/2008)

---

How do i know its actively using all?

My understanding is - what ever is allocated to SQL - it wont grab it until it's required. Atleast on SQL 2005...

Do not shrink the database unless disk space has become a critical issue....There is nothing to be gained by...

That's not true, I have users in when an autogrow is initiated....

sam (7/25/2008)

---

To add to this:

Like he...

What OS are you running? Google "Not enough server storage is available to process this command." It returns a lot of hits, some from MS pointing to changing reg values,...