I am a Software Engineer.
My key interest are C#,SQL and some other latest technologies.
When i am researching on some thing.I am Updating my blog,for my backups.If this blog that help others.Then i am so happy.
Linkedserver is used to execute command againstOLEDB datasource on different server.
·Remote server access
·Distibuted query ,update,command and transaction on heterogeneous datasource across the enterprice.
·Ability to address diverse datasource similarity
Linked Server components :
Oledb provider and oledb datasource
Oledb provider-is a dll that manages and interact with specific
Linked server details
Whena client appln execute a distributed query through a linked server ,sql server break down into command and send it to rowset and req to oledb. The row set exec and open the table from the provider.
Managing linked server Definition
To work in linked server ,register the connection formula and datasource informationto sql server .After registration datasource ll always reffer to the logical name provided.