See reply inline.

begin tran

truncate table cs_ord

go --- why do you need go here?

insert into cs_order_amts_all(Order_Num, Amount)

SELECT T1.SO as Order_Num,

CASE WHEN (SUM (T1.C_CHORHI_CHANGE_NUM = '0')

                        THEN (T1.AMT)

                                 ELSE (T1.CHANGE_AMT)

                       END...

Can you show your codes here?

It seems the SQL Server Agent account has to have permissions to access foxpro database like "alan".

" I'm really struggling with this one. It appears to be load related, in that it will occur at times of heavy usage. "

I agree with you. It is realted...

What privilege the ".\administrator" has in SQL Server? SQL Server Agent is running under local system account that can't access the FoxPro data which is in client machine. You have...

No idea why your delete statement generates such complex execution plan.

Here is my example.

delete from dat_audit where id = 1

  |--Table Delete(OBJECT[INITLC].[dbo].[DAT_AUDIT]))

       |--Top(ROWCOUNT est...

"