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.
Showing posts with label capture. Show all posts
Showing posts with label capture. Show all posts
Sunday, February 19, 2012
Subscribe to:
Posts (Atom)