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.
select into can be replicated in warm standby configurations by using SQL statement replication. To configure SQL statement replication at the database level, use:
sp_setrepdbmode pdb, 'S', 'on' go
Once the option is active at database level, all select into operations in database pdb will be replicated using SQL statement replication. See “Exceptions to using SQL statement replication” to verify that the query can be replicated using SQL statement replication. If only a subset of select into needs to be replicated, use set repmode instead.
