Problems after migrating to sql 64

Last Post 18 Nov 2004 07:13 PM by VladRUS. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

15 Nov 2004 09:35 AM
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.

Any suggestions?


New Member
New Member

18 Nov 2004 07:13 PM
You should use linkedserver for this kind of problems.

Acceptable Use Policy