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.