When I try to create and manage publication in SQL 7.0, I got the following
error message:
Error 21085: The retention period must be less than the retention period for
the distribution database.

I try to create publishor and distributor on the same server.

Thank you.

can you do a sp_helpdistributor and sp_helppublication. Note the retention
period for your distributor. The retention period for your publication
should be less than or equal to the retention period of your distributor.

--
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html


"royHe" <royHe (AT) discussions (DOT) microsoft.com> wrote