Calling Stored Procedure on Linked Server

SQL SERVER – Executing

Remote Stored Procedure – Calling Stored Procedure on Linked Server - SQL 2000

Prerequirement : Create and configure the linked server

Syntax to call the procedure :

EXEC [RemoteServer] .DatabaseName.DatabaseOwner.StoredProcedureName

Please make sure the RPC is checked in the property tab of Linked server (Server opt

ion tab)