SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 ling database
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

MARINOS
Starting Member

13 Posts

Posted - 03/17/2006 :  18:14:06  Show Profile
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

USA
36845 Posts

Posted - 03/17/2006 :  18:45:28  Show Profile  Visit tkizer's Homepage
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
Flowing Fount of Yak Knowledge

India
1907 Posts

Posted - 03/18/2006 :  01:33:21  Show Profile  Visit chiragkhabaria's Homepage  Send chiragkhabaria a Yahoo! Message
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 - 03/18/2006 :  06:44:12  Show Profile
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
Flowing Fount of Yak Knowledge

India
1907 Posts

Posted - 03/18/2006 :  06:53:46  Show Profile  Visit chiragkhabaria's Homepage  Send chiragkhabaria a Yahoo! Message
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 - 03/18/2006 :  06:55:34  Show Profile
when i am runnig a guery i get the error
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36845 Posts

Posted - 03/18/2006 :  23:46:00  Show Profile  Visit tkizer's Homepage
Please post your code that is causing the error plus the actual error.

Tara Kizer
aka tduggan
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000