Create linked server from 64-bit SQL to 32-bit SQL or use a join query
Posted on 2013-11-01
I have one database on a 64-bit version of SQL Server 2008. I have another "Linked Server" in my 32-bit SQL Express instance on the same server.
I was going to try to create another linked server with my 64-bit instance to the 32-bit instance, but SQL Mgmt Studio isn't recognizing it.
My other option was to use join statements to connect the two, but that doesn't seem to work, either.
How can I get the 32-bit piece to talk to the 64-bit piece? I can see both of them in my SQL Mgmt Studio, obviously in separate connections to the SQL instances.