Administrators can create remote procedures in Interactive SQL.
You must have the MANAGE REPLICATION system privilege.
If a remote procedure can return a result set, even if it does not always return one, then the local procedure definition must contain a RESULT clause.
This example specifies a parameter when calling a remote procedure:
CREATE PROCEDURE RemoteUser ( IN username CHAR( 30 ) ) AT 'bostonase.master.dbo.sp_helpuser'; CALL RemoteUser( 'joe' );