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 |
|
hornet
Yak Posting Veteran
96 Posts |
 Posted - 2005-12-28 : 04:55:38
|
Hi! I from Russia so I bad speak English. Sorry.  Question: I need to call stored procedure and function on remote server. How Can I do it?Thanks in advance! |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2005-12-28 : 05:52:46
|
| First you need to link both the servers |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-28 : 05:54:39
|
| Link the remote server by sp_addLinkedServer and call themLook for sp_addLinkedServer in SQL Server help fileAlso refer OpenRowSet and OpenDataSourceMadhivananFailing to plan is Planning to fail |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-28 : 10:09:45
|
| Your English seems finesee this alsohttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=43050 |
|
|
|
|
|
|
Call of stored procedure