Conflict table cleanup interval

What replication parameter sets the interval in which data in the conflict tables is deleted in SQL Server 2000 SP4?Apparently when the snapshots are generated the conflict tables are cleaned out as part of the process. This was causing my conflicts to disappear each night when the snapshot agent ran.|||

Rerunning snapshot should not be cleaning the tables.

@.conflict_retention governs how long the data will be kept in these tables before purging.

|||If I have data in the conflict tables and then execute the snapshot SQL Agent job the conflict tables are cleaned out. I have the @.conflict_retention value set to 90 days.
The publication is a filtered merge publication.|||

Sorry I missed your earlier comment that this was SQL Server 2000.

This is a known issue in SQL Server 2000 and has been fixed in SQL Server 2005.

Conflict data automatic cleanup

What replication parameter sets the interval in which data in the
conflict tables is deleted in SQL Server 2000 SP4?
The data in my conflict tables appears to be deleted every night.
From BOL: "The Merge Agent deletes data from the conflict table if it is
older than the conflict retention period for the publication, which is
specified using the @.conflict_retention parameter of sp_addmergepublication
(the default is 14 days)."
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||the default is every 14 days. You set it with @.conflict_retention parameter
of sp_addmergepublication
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"zebra1024" <jcmackenzie@.gmail.com> wrote in message
news:1163168845.703224.81300@.f16g2000cwb.googlegro ups.com...
> What replication parameter sets the interval in which data in the
> conflict tables is deleted in SQL Server 2000 SP4?
> The data in my conflict tables appears to be deleted every night.
>
|||I thought that was the parameter but my conflict tables seem to be
cleaned out each night even though this parameter is set to 14. Does
generating the snapshots clean out these tables also?
Paul Ibison wrote:
> From BOL: "The Merge Agent deletes data from the conflict table if it is
> older than the conflict retention period for the publication, which is
> specified using the @.conflict_retention parameter of sp_addmergepublication
> (the default is 14 days)."
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||I just tested this and apparently generating the snapshots does clean
out the conflict tables.
zebra1024 wrote:[vbcol=seagreen]
> I thought that was the parameter but my conflict tables seem to be
> cleaned out each night even though this parameter is set to 14. Does
> generating the snapshots clean out these tables also?
>
> Paul Ibison wrote:
|||Very interesting - thanks for the update. I'll request a BOL update for
this, as it is not mentioned in the right place (if at all).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Confined by table cells .. Col span option?

Under a table with headers, groups, details and footers .. say I want
two sets of details that should not align with the headers. Or for
example, say I have a subreport in a group that I would lke to span the
entire width of the the table.. How do I do this?
Thansk.Have you tried merging the cells?
"jobs" <jobs@.webdos.com> wrote in message
news:1162310445.109140.233360@.m73g2000cwd.googlegroups.com...
> Under a table with headers, groups, details and footers .. say I want
> two sets of details that should not align with the headers. Or for
> example, say I have a subreport in a group that I would lke to span the
> entire width of the the table.. How do I do this?
> Thansk.
>|||Noob here. How do you select more than one cell so the merge option is
enabled? shift right arrow does not seem to work for me and I can't
seem to lasso inside a table.
Sebasti=E1n G=F3mez wrote:
> Have you tried merging the cells?
> "jobs" <jobs@.webdos.com> wrote in message
> news:1162310445.109140.233360@.m73g2000cwd.googlegroups.com...
> >
> > Under a table with headers, groups, details and footers .. say I want
> > two sets of details that should not align with the headers. Or for
> > example, say I have a subreport in a group that I would lke to span the
> > entire width of the the table.. How do I do this?
> >
> > Thansk.
> >|||Select the cells you want to merge, then right click 'Merge Cells'.
"jobs" wrote:
> Noob here. How do you select more than one cell so the merge option is
> enabled? shift right arrow does not seem to work for me and I can't
> seem to lasso inside a table.
> Sebastián Gómez wrote:
> > Have you tried merging the cells?
> >
> > "jobs" <jobs@.webdos.com> wrote in message
> > news:1162310445.109140.233360@.m73g2000cwd.googlegroups.com...
> > >
> > > Under a table with headers, groups, details and footers .. say I want
> > > two sets of details that should not align with the headers. Or for
> > > example, say I have a subreport in a group that I would lke to span the
> > > entire width of the the table.. How do I do this?
> > >
> > > Thansk.
> > >
>

Configuring Charts for more than one axis

In Excel it is possible to have a primary and a secondary axis. This would allow for a chart to show to related data sets that have vastly different scales. Is this possible in Reporting Services.Sorry, this is currently not supported out-of-the-box. There are add-on products (e.g. Dundas Chart for Reporting Services) that can plug into RS 2005 and provide that capability.

-- Robert