Elliott,

Increasing the memory allocation in SQL Server has fixed our import problem. All of the data imports that have been failing are working again.

Thank you very much...

Elliott, thanks for your help with this. I worked with my DBA this morning to reconfigure the server to use 4GB of memory instead of the apparent 2GB that...

Yes, PAE is set in the OS startup. However, I've been doing some research after your earlier suggestion and it looks like AWE is not enabled on any of...

Ok, I'm interested to see where this goes, especially since it appears that our DR instance uses slightly more RAM than the other two.

OS = Windows Server 2003 Enterprise Edition...

Thanks for the suggestions; I really appreciate it because it gives me something else to look at that I might not have considered.

I don't think memory's an issue though. ...

The MSDASQL provider for our Linked Server connection has the "Allow inprocess" property enabled. This is true for all three instances.

Also, this does work many times throughout the day....