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, in order to define operations at the database-level, you must have replication configured at the database level as well. For example, you cannot execute:
sp_reptostandby pubs2, ‘none’ go sp_setrepdbmode pubs2, ‘udis’, ‘on’ go
