sql server replication: My company is planning on setting up Reporting Services for our application
to report from a secondary SQL Server instance. But we want to archive data
to our secondary instance and be able to "clean up" our OLTP instance when
data is no longer needed on the transactional side. We would like to use
replication, but there does not seem to be an inherent way to prevent delete
operations on the Publishing instance from getting passed down to the
Subscriber instance without implementing some sort of date-time stamp support
manually and then filtering.

Is there some inherent support (or third party code) for an operation like

Thank you for your quick response.

[quoted text, click to view]