Have Geek Brain

Are there any known issues using linked servers between 64 bit sqlserver2005 and 32 bit sql2000

I seem to be having problems getting linked servers running queries between databases / servers running on sql2000 32bit and 64bit sql2005. Is this a known bug? If so, is there a workaround or fix?

0


a source to share


1 answer


Well, that's the question .



To resolve this issue, manually run the Instcat.sql script that is included with SQL Server 2000 SP3 or SP4 on a 32-bit SQL Server 2000 server or on a SQL Server 7.0 server.

+1


a source






More articles:


All Articles