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 ......