"Doug" <Doug@discussions.microsoft.com> wrote in message
news:9C69367C-BE36-4373-95AA-33E1E5C87640@microsoft.com...
> In SQL 2005, how do you look at, and ultimately update, system tables such
> as
> a MSmerge_conflict_publication_article table? I can't find an
> INFORMATION_SCHEMA view that allows this. Currently in SQL 2000, I will
> periodically purge the conflicts that have been recorded in these type of
> tables and want this ability in SQL 2005.
>
> Thanks,
>
> Doug

"Hilary Cotter" wrote:

> You can manipulate the contents of this table using the conflict viewer.
>
> --
> 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
>
>
>
> "Doug" <Doug@discussions.microsoft.com> wrote in message
> news:9C69367C-BE36-4373-95AA-33E1E5C87640@microsoft.com...
> > In SQL 2005, how do you look at, and ultimately update, system tables such
> > as
> > a MSmerge_conflict_publication_article table? I can't find an
> > INFORMATION_SCHEMA view that allows this. Currently in SQL 2000, I will
> > periodically purge the conflicts that have been recorded in these type of
> > tables and want this ability in SQL 2005.
> >
> > Thanks,
> >
> > Doug
>
>