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