Issues Resolved by SQL Statement Replication

In some cases, data cannot be replicated using traditional replication methods. SQL statement replication provides a way to replicate data successfully in such situations .

• Replication of the select into Operation In Warm Standby Configurations
  select into creates a new table based on the columns specified in the select list and the rows chosen in the where clause. This operation is minimally logged for recovery purposes, and cannot be replicated using traditional replication.
• Replication of Deferred Updates on Primary Keys
  Updates on tables that have a unique column index are not supported by traditional replication, and the Replication Server reports errors.