Couple of things that I have found:

1. EM uses a ton of tempdb. If tempdb is getting hammered, you may have a disk IO issue. Look at the disk...

Well, my opinion is the use of views for consistancy. I believe that like programming subroutines, this makes the job of debugging simpler and lends itself to more readable...

Leon, you are correct. My appologies, I missed a AND clause on the second query.

It should have read:

SELECT *

FROM tbl1

INNER JOIN tbl2 ON tbl1.key = tbl2.key

WHERE tbl2.filter = 1

AND...

It is not the last step. It is not a specific step. Like I said, if I stop and start the program, it restarts on the same entry...

Are you running replication agents (epecially merge and log reader agents)?

Alternatively, do you have any DTS packages or Command Executable Jobs which are scheduled during these times?

Also, are you using...

Try the following (treat this like a REGEDIT hack as this can be dangerous)

sp_configure 'allow updates', 1

GO

RECONFIGURE WITH OVERRIDE

GO

Then try it again (set this back to 0 only if this...

Actually this is a IO bottleneck and not memory. Memory shows up as RESOURCE_SEMEPHORE.

This is a wait for the IO channel to read a Page from the IO Channel....

2 Things

NT 4 Resource Kit has both a Telnet Server and a RSH server.

Windows 2000 has the Telnet server build in and I believe the resource kit has the RSH...

If you are still having problems with EM try creating a ALIAS in the CLIENT NETWORK utility which forces connections to your server over TCPIP. We had this same...

Have you tried DROP TABLE from ISQL. I know that SQLEM blocks these but I have had luck with this. If this does not work, I can give...