Schema synchronization when current database has a system proxy database  Additional behavior of the system proxy database

Chapter 2: Understanding Component Integration Services

Stored procedure execution within a system proxy database

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.





Copyright © 2005. Sybase Inc. All rights reserved. Additional behavior of the system proxy database

View this book as PDF