How can we Use Linked Server? Uses of Linked server
- 1 Answers
- 5140 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / samba shiva reddy . m
A linked server configuration enables SQL Server to execute commands against OLE DB data sources on remote servers.
Linked servers offer the following advantages:
Remote server access.
The ability to issue distributed queries, updates, commands, and transactions on heterogeneous data sources across the enterprise.
The ability to address diverse data sources similarly.
How to link another server in SQL Server 2005?
Go to Server Objects-->Linked servers
Right click on linked Servers it will give option to create new server give the remote server name
or
Basically – all I needed to do what set up a linked server by using the following system stored procedures:
sp_addlinkedserver '<Server Alias>', '', 'SQLNCLI', NULL, NULL, 'SERVER=<IP>', NULL
sp_addlinkedsrvlogin '<Server Alias>', 'false', NULL, '<username>', '<password>'
To remove the linked server once done then just call
sp_dropserver '<Server Alias>', 'droplogins';
example : u have another data base is running in different server(System) u need some tables,columns from that Server to write some query in that query u need that columns so u have to link with that server using above scenario then u can use those columns in your query.
for instance set up a linked server called myRemoteServer, then I would be able to access a table in the remote database using:
myRemoteServer.<DatabaseName>.dbo.<TableName>
It makes it relative much easier to map data between sources compared to having to backup/restore the remote source database to the target server.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the beast way to write CTE in SQL Server ?
What are various aggregate functions that are available?
Does view occupy space?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
Which is faster statement or preparedstatement?
Can We Use Data-grids For Our Report In Ssrs?
Tell me what is difference between view and materialized view?
Explain database normalization?
Explain the categories of stored procedure?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
whats the maximum size of view state??
Is it important for a database administrator to understand the operating system and file access?
How to create a trigger for insert only?
Explain transaction server consistency?
What is difference between aggregate and analytic function?
