Help in addLink servers

[techipa]

Hello All,

Can anyone tell me how to add the server using sp_addlinkedserver? I have not done this task before. The server which I need to add is SQL server 2000 and the destination is SQL server 2005.


Thanks in advance,
-techiPA

 

[ptheriault]

If you search BOL (books on line) for sp_addlinkedserver
This is the results. They also have a lot of examples.


sp_addlinkedserver [ @server= ] 'server' [ , [ @srvproduct= ] 'product_name' ]
[ , [ @provider= ] 'provider_name' ]
[ , [ @datasrc= ] 'data_source' ]
[ , [ @location= ] 'location' ]
[ , [ @provstr= ] 'provider_string' ]
[ , [ @catalog= ] 'catalog' ]


- Paul
- If at first you don't succeed, find out if the loser gets anything.