Linked server

Question

Post reply

Linked server

su_kumar11

SSCommitted

Points: 1675
More actions
August 19, 2008 at 10:02 pm

#154640

Hi,
Could any one tell me that how to configure and how to work on Linked Server in Sql server 2005?
Regards,
Sunil

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Anam Verma SSCertifiable Points: 5365 More actions · Answer 1

the best place would to read BOL. you can find about linked servers at

http://msdn.microsoft.com/en-us/library/ms188279.aspx

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 2

what exactly you want to do ??

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Red8Rain Hall of Fame Points: 3312 More actions · Answer 3

sp_addlinkedserver is the syntax you want to use

it allows you to query remote servers w/o having to actually connect to it.

[from serverA]

exec serverb...sp_who2 active

-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool[/url] :.

babloo.sqlnut SSC Enthusiast Points: 183 More actions · Answer 4

does every company have linked servers ??

What If the link between SQL Server and remote server is not reliable ??

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 5

see linked server is not a physical machine ...when we want to execute a query from server A to server B...then Server B act as Linked server

Linked is established with the help of

SP_ADDLINKEDSERVER 'servername'

And reliablilty is depended on login we use to established connection...

this is the brief from my side

for details refer book online....or scratch GOOGLE...:)

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

leileif Valued Member Points: 55 More actions · Answer 6

You can use New Linked Server wizard to create a linked server in sql server 2005. I had created one named JGPRD which is linked to a Oracle database. To query on linked server, you basically need to specify the linked server name, schema and object (table, view ...). For instance:

select*

FROMJGPRD..ENERGYDB.LL_DMSEBG120

Here JGPRD is linked server name and ENERGYDB is the schema.

Bear in mind, if linked server is Oracle db, you may need to use capps for all objects name, otherwise you may get error message