I just checked my production merge tables and it appears that records are being removed from MSmerge_contents, MSmerge_genhistory, and MSmerge_tombstone.

As I mentioned in my first posting, I recently changed the setting...

Noel, thank you very much for the clarification.

So how would one go about cleaning up merge metadata if they are running in a continuous mode? 

Thanks again,

Barbara

Thank you all very much for your time and your responses. 

This site is great for sharing knowledge and I don't know what I would do without it.

Thank you all...

Thank you again Glen for your help.  I plan on setting up the test merge environment to test some of this out. 

I should have mentioned in my original email...

Thank you both for your help

I had a few questions about both of your comments.

I am running SQL2K with sp3.

What job automatically calles sp_mergecleanupmetadata?

I did go to BOL but I...

Hello,

I think I found my answer.  Please check

http://support.microsoft.com/kb/q236407/

if you run into the same issue.

Barbara

Thank you all for your help.

Here is a sample of how the data looks when it is retrieved:

o Manager and Assistant Manager of Consultant Accounting

 Calculated/tracked engagement performance

 Conducted sensitivity/scenario analyses

It seems strange...

The data is being entered via a CF form as a text area.

When the data is returned it is one long string of text, and characters get replaced.  For example...

Thanks for responding.

I neglected to mention that we are running merge replication so I don't know if your suggestion will work.  Would this be my only option?

Thanks again

I don't know if it works the same for SQL 2003? however I had this issue with merge replication in 7.0 and I found the following information which was helpful...