SQLTeam.com | Weblogs | Forums

Calling a Stored Procedure on a Linked Server


#1

Hello

I have a stored procedure that after the desired treatments calls another procedure on another server

Example:

Alter myproc @ variable1 int
As
Begin
--Treatment
....
....

Exec [Server2]. [Mydatabase] .dbo.Myproc2 @ variable1
End

I have this message:

Msg 7411, Level 16, State 1, MyProc Procedure, Line 237
Server 'Server2' is not configured for RPC.

Knowing that I have configured the linked server and was able to write to Server2 by the request "Insert into [Server2] .Mydatabase.dbo.Table1 ......


#2

Found the link RPC


#3

thanks

I found it

it's OK