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.What about linked server?|||As mentioned using linked server and OPENQUERY you can be able to select/update data between 2 servers.
Refer to books online for linked servers topic.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment