Error: Server ‘SERVERNAME’ is not configured for RPC
Code:
EXEC [LINKEDSERVERNAME].[DATABASENAME].dbo.[STOREDPROCNAME]
Problem: Attempting to execute a stored procedure across a SQL Server Linked Server
Fix: Enable “rpc out”
EXEC master.dbo.sp_serveroption
@server=N'LINKEDSERVERNAME'
, @optname=N'rpc out'
, @optvalue=N'true'
GO
