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.

What is difference between stored procedure and user defined function?

1029

---

Name the different type of indexes in sql?

907

---

What specific conditions database should meet, before you can bulk copy data into it using bcp?

934

---

What are the advantages of sql azure?

138

---

Which are the new data types introduced in sql server 2008?

843

---

Explain the various types of concurrency problem?

1136

---

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

139

---

What is set nocount on and what is set nocount off?

885

---

Does order by actually change the order of the data in the tables or does it just change the output?

1079

---

Is it safe to delete log files?

868

---

What is a system database and what is a user database?

1028

---

How can you know if the row fetched from cursor is still valid in underlying table?

953

---

Explain left outer join and right outer join?

972

---

How to drop an existing table?

958

---

How do I perform an unattended install of sql server 2000?

1018

---