If a system stored procedure request is encountered when the current database is a system proxy database, Component Integration Services attempts to locate the stored procedure first in the local sybsystemprocs database, and execute it. If it is not found in sybsystemprocs, Component Integration Services searches the master database. If the procedure is not a system stored procedure, or if it is but cannot be found locally, the stored procedure request is converted to an RPC and transmitted to the server referenced by the system proxy databases default location.
