I am updating a column in table from a table on another server and am having some troubles.
My code looks like this...
SET COLUMN1A = SERVER2.DATABASE2.SCHEMA2.TABLE2.COLUMN2A
FROM TABLE1, SERVER2.DATABASE2.SCHEMA2.TABLE2
WHERE TABLE1.COLUMN1B = SERVER2.DATABASE2.SCHEMA2.TABLE2.COLUMN2B
I keep getting "The multi-part identifier ____ could not be bound."
Security rights are in place and I have access to Server2
View Complete Post