I am trying to execute a stored procedure on a linked MSDE 8.x server by running the following SQL against the parent SQL Server 2000 instance...
DECLARE @RC int EXECUTE @RC = [LINKED_SERVER_NAME].[LINKED_SERVER_DATABASE].[dbo].[STORED_PROCEDURE_NAME] GO
...but I get this error message:
Msg 7411, Level 16, State 1, Line 2 Server 'LINKED_SERVER_NAME' is not configured for RPC.