SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 remote procedure
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

ravilobo
Flowing Fount of Yak Knowledge

India
1184 Posts

Posted - 02/06/2006 :  08:31:26  Show Profile
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

India
22765 Posts

Posted - 02/06/2006 :  08:42:58  Show Profile  Send madhivanan a Yahoo! Message
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
Flowing Fount of Yak Knowledge

India
1184 Posts

Posted - 02/06/2006 :  09:14:37  Show Profile
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

India
22765 Posts

Posted - 02/06/2006 :  09:16:16  Show Profile  Send madhivanan a Yahoo! Message
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
Flowing Fount of Yak Knowledge

India
1184 Posts

Posted - 02/06/2006 :  09:27:10  Show Profile
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

India
22765 Posts

Posted - 02/06/2006 :  09:39:31  Show Profile  Send madhivanan a Yahoo! Message
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
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000