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.
| 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 Kizeraka tduggan |
 |
|
|
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.. |
|
|
|
MARINOS
Starting Member
13 Posts |
Posted - 2006-03-18 : 06:44:12
|
| i have all ready call the sp_addlinkedserver but its dosent worki have an error for maximun character |
|
|
|
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.. |
|
|
|
MARINOS
Starting Member
13 Posts |
Posted - 2006-03-18 : 06:55:34
|
| when i am runnig a guery i get the error |
|
|
|
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 Kizeraka tduggan |
|
|
|
|
|
|
ling database