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, CIS functions will then be called upon to:
grant create table to public - this will allow table creation on the primary server to result in proxy table creation in the system proxy database.