Yes I tried to execute the DTs package outside the job and it worked fine.

first I enabled AWE and then recycled the service and then set /3GB /PAE in boot.ini and then rebooted the server. Which I believe was not exactly how should it...

Hi All,

Thanks for great response. Seems like everything has started falling in place now.

I have allocated 4 GB to first 2 instances and 1 GB each to the remaining 2 instances....

Thanks sa24.

According to your calculations can I make it :

inst1 - 4gb

inst2 - 4gb

inst3 - 1gb

inst4 - 1gB

right ?

Also why ( 7 - 4.5&nbsp ?...

No I dont see the AWE enabled message in my SQL error log.

Now I have increased the max server memory to 3001 MB. I guess I will have to...

Ours was Windows 2000 .... I dont know if it applies to win 2003.

http://support.microsoft.com/default.aspx?scid=kb;en-us;811392

One possibility could be that the hard drive on your server has some bad sectors.

When I was having this very same problem on the server almost two years ago, it was...

Its on a windows 2000 Server with SP4. Yes I am able to connect to both the instances from other machines thru TCP/IP as they are running on different ports.

Thanks.

I dont know if you are from Idera and trying to get feedback from the user community about DM

Earlier we had to...

Yes, I am a sysadm on all the instances on that box. It works on instance1 , instance2 and instance4.

I tried connecting as 'SA' but still getting the same thing.

Thanks.

I dont know if this is of any help.. but still

We had the same kind of problem on sql 2000 server after we installed OS SP3 on Win 2000. After...

Thanks for your reply Jmvdam,

Finally I was able to resolve the issue. Here is the Q article in which Microsoft admits that it is a known issue and there is...

Thanks racosta..

But even that didn't work. So finally I had to rollback to the older version (Outlook 2002) and now it is working fine.

Ya... even I would like to have a look at the new script with @query parameter.

"Mom" do you see any other pros with SMTP mail ?

Thanks.

Thanks All,

The actuall query is very big, I just wanted to summarize it in this post and get some suggestions. I am sorry if I have confused anyone.

But I did...