Force Replication of DDL Commands to the Standby Database

Use set replication force to force replication of supported DDL commands and system procedures.

For example, to force replication of all supported DDL commands and system procedures for an isql session, enter:

set replication force_ddl

This command enables replication of DDL commands and system procedures for tables marked with sp_setreptable.

To turn off force_ddl and return set replication to default status, enter:

set replication default