PrepAway - Latest Free Exam Questions & Answers

Tag: sql server queued replication retention period

Which system stored procedure should you use?

You are the database administrator of your company. You have configured merge replication on an instance of SQL Server 2008.
You configure the Publisher and Distributor for error reporting and monitoring purposes.
You create a publicationwith the default retention period. Users want to be able to subscribe to the publication for a longer period of time.
You want to modify the expiration period for the subscription to the publication.
Which system stored procedure should you use?