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 |
|
Finarfin
Starting Member
28 Posts |
 Posted - 2004-06-28 : 11:39:57
|
| Hello,I have a target database in a server, and the source database is in a distant server from the target.I have stored procedures in the target server, what do you think is the best, to make them point towards the source server??Thank you all,Romain |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-06-28 : 12:36:28
|
| I'm not sure I understand the question, but It sounds like you want to use Linked Servers.Look up Linked Servers in Books Online.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
Finarfin
Starting Member
28 Posts |
Posted - 2004-06-29 : 04:48:48
|
| It sounds like you are right. But we have administror rights problems so I cant access the other server because I am not enable. I have to see with the administrator.thank youThank you all,Romain |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-29 : 07:59:24
|
| Well, if you don't have administrator rights or the account for the other server, there's not a whole lot you can do. :) Look into OPENROWSET in Books Online. That might give you what you need.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
insert from distant server