Set Thresholds and Configure Replication

You can have a database that is not configured for replication and set the threshold for SQL statement replication at the database level at the same time.

For example:

sp_reptostandby pubs2, ‘none’
go
sp_setrepdbmode pubs2, ‘threshold’, ‘23’
go

However, to define operations at the database level, you must also configure replication at the database level. For example, you cannot execute:

sp_reptostandby pubs2, ‘none’
go
sp_setrepdbmode pubs2, ‘udis’, ‘on’
go