I am fairly new to the whole DBA scene. With that said, i was able to get an ODBC connection established within Microsoft SQL Server 2012 to be able to access a database for a library. Now what I am trying to do is create queries to be able to manipulate that said DB within Microsoft SQL Server but am having trouble finding ways to be able to do so. Can someone please help teach me how to call upon that Linked Server DB to be able to manipulate it as I see fit. Thank you in advance.
closed as too broad by Max Vernon, RolandoMySQLDBA, mustaccio, Paul White♦ Jun 9 '16 at 2:38
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
A linked server is referenced just like you would reference a database, with multi-part naming -
LinkedSvrName.DBName.SchemaName.ObjectName. There isn't really anything else to "accessing" a linked server.
There are some settings you will need to be cognizant of to ensure you can return data;
RPC Out for instance. Also you will want to use linked servers sparingly as performance will suffer. This should get you well on your way to Googling the rest of what you need to know. This topic is really too broad to be covered in this format.