A system proxy database is created automatically under the following circumstances:
The HA cluster is being configured through the use of the stored procedure sp_companion ServerName, ’configure’, with_proxydb.
In this case, a system proxy database is created for each user database found in server indicated by ServerName.
A create database command is issued in a server whose HA state is one of MODE_APNC, MODE_SNC, or MODE_ASNC.
When the creation of the system proxy database is complete, Component Integration Services functions are called upon to:
grant create table to public – this allows table creation on the primary server to result in proxy table creation in the system proxy database.
