Unanswered: Accessing table in Server A while in Server B
How would I select data from a table in a server called A while I am in a server called B? I am trying to capture the data in server A in a stored procedure within server B. I attempted using syntax similar to
A.database.dbo.tablename but it gave me an error. Please let me know. Thanks.