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.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 remote procedure

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 query
Look for sp_AddLinkedServer in BOL

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

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
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-02-06 : 09:16:16
Did you try this?
EXEC ServerName.DBName.OwnerName.SpName 'Parameters' -- if any

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

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 1
Server 'etlive' is not configured for RPC.
---------------------------------------------

------------------------
I think, therefore I am - Rene Descartes
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-02-06 : 09:39:31
You need to configure that. Refer this
http://www.informit.com/articles/article.asp?p=21644&redir=1


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -