Interesting. Try to refresh the database, restart the EM.

Check the query execution plan to see whether it runs in parallel in server.

Any object created by any member of the sysadmin fixed server role belongs to dbo automatically. Because you are the member of 'sysadmin' so objects created by you will belong...

I don't see any blocks from the result of sp_who2.

http://www.microsoft.com/sql/howtobuy/serverpluscal.asp

Quoted from http://www.sqldts.com/default.aspx?6,105,212,0,1

"They only way to permanently reflect a change of owner is to use the Save As function in the DTS designer. This creates a new package, not just...

Can you reproduce this problem? During the insert, Run sp_who2 to see who is blocking the insert from Tab_A to Tab_C.

http://www.sqldts.com/default.aspx?212

Change the database owner to 'sa using sp_changedbowner. Make sure database objects owned by DBO before you change it.

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

Gary,

I heard this solution before and someone said this could cause database inconsistency.

Could it be hardware issues? How long did you see Disk Queue Length around 60 lasts?

Run sp_helpdb to see who is database owner.

xp_cmdshell 'DTSRUN.EXE ....', See BOL DTSRUN for details.

From Cluster Administrator --> right click SQL Server resource --> Property --> Advanced Tab --> See what is your pending timeout value.