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 |
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-02-06 : 08:31:26
|
I have a SP on one server, which needs to be executed from another server. How to achieve this?------------------------I think, therefore I am - Rene Descartes |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-06 : 08:42:58
|
Add other server as Linked Server and do queryLook for sp_AddLinkedServer in BOLMadhivananFailing to plan is Planning to fail |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-02-06 : 09:14:37
|
I know how to create a linked server. I am firing a query which executes successfully. But how to execute a SP?------------------------I think, therefore I am - Rene Descartes |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-06 : 09:16:16
|
Did you try this?EXEC ServerName.DBName.OwnerName.SpName 'Parameters' -- if anyMadhivananFailing to plan is Planning to fail |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-02-06 : 09:27:10
|
Yes I am trying the same thing mentioned by you... I am getting the following error---------------------------------------------Server: Msg 7411, Level 16, State 1, Line 1Server 'etlive' is not configured for RPC.---------------------------------------------------------------------I think, therefore I am - Rene Descartes |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|