hi all we have a situation here , we do lot of transactional replication, our distribution database is on our main production server , every other day replication agent failure occurs with different reasons. Some of the errors I observed are Some of the errors I observed are 1.unable to open sp_replMerge...... 2.while logreader agent running it is creating millions of locks(which i came over by changing the logreader agent profile) 3.subscription is failing with the error. row not found at the destination. 4.Server which is hosting distribution database is running out of space. My question is do we have to put the distribution database to fixed size or autogrow in database option and do we have to set the option autoshrink in the distribuiton database. Any help on this would be helpful. Thanks in advance.