I have had some problems after migrating to SQL Server 2000-64 bits. Currently, I am having a problem updating a 32 bits server database with information retrieved from a 64 bits server database.
Insert into INSTANCE32.Table1
exec INSTANCE64.MyStoredProcedure 11, 2004
After a couple of minutes this process times out.
"exec MyStoredProcedure 11, 2004" is returning the correct results. Also, if I do the Insert values returned by a select statement from a table in the same 32 bits server the operation completes withount problems.