Federated stored procedures

Federated procedure access enables users of federated systems to access remote stored procedures at remote data sources.

A federated stored procedure is a local stored procedure that is mapped to a stored procedure at a data source. You use the CREATE PROCEDURE (Sourced) statement to register a federated stored procedure.