Lowell (8/14/2012)
lets double check some settings...by abstracting out your code to be anonymous (SERVERA and SERVERB, something got lost, i think.first, i don't think its necessary to use EXECUTE AT.
you can use an alias just like you were using..
When using alias, the sp is running really slow, sometimes causing a block on this very update statement
the syntax you are using for update requires the SERVERB to be a SQL server...
the command you are using requires SERVERB to have a linked server to SERVERA
Yes Server B has a linked server back to ServerA
from what you posted, the opposite is true..SERVERA has a linked server, but not necessarily the reverse.