Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 ling database

Author  Topic 

MARINOS
Starting Member

13 Posts

Posted - 2006-03-17 : 18:14:06
hi
i have 2 server and 2 db. the first purchases server and db and second sales server and db .
i would like to take the information for the purchases db in sales server or sales db in purcases server.

how to connect this 2 servers and db?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-03-17 : 18:45:28
You can use a linked server if you want to run queries that pull from two databases on separate servers. Check out linked servers in SQL Server Books Online for details.

Tara Kizer
aka tduggan
Go to Top of Page

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-03-18 : 01:33:21
Check out for the procedure call sp_addlinkedserver on the SQL Bol..

you need to link both the servers then you can call other sever from the current server using the server name..


Sucess Comes to those who Believe in Beauty of their Dream..
Go to Top of Page

MARINOS
Starting Member

13 Posts

Posted - 2006-03-18 : 06:44:12
i have all ready call the sp_addlinkedserver but its dosent work
i have an error for maximun character
Go to Top of Page

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-03-18 : 06:53:46
while running sp_AddlinkedServer you are getting this error or when you are run some query you are getting error??

Can you give some more clues so that we can help you..

Sucess Comes to those who Believe in Beauty of their Dream..
Go to Top of Page

MARINOS
Starting Member

13 Posts

Posted - 2006-03-18 : 06:55:34
when i am runnig a guery i get the error
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-03-18 : 23:46:00
Please post your code that is causing the error plus the actual error.

Tara Kizer
aka tduggan
Go to Top of Page
   

- Advertisement -