[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Multiple conflict and aonflict tables created

Posted on 2006-05-31
3
Medium Priority
?
321 Views
Last Modified: 2008-01-09
When setting up the replication between servers and SQL instances I had to reconfigure it a few times.  Now in the database that is replicated there are multiple conflict and aonflict tables.  Can I clear these out and if so how do I go about this?  It looks like the aonflict and conflict ones are the only ones that are getting updated data but I have 3 others that are conflict1, conflict2, and conflict3 tables.  The dates in those tables are from when I was messing around with various types of replication.  Can anyone tell me if I can clear these out?

Thanks
0
Comment
Question by:mfehrmann
1 Comment
 
LVL 5

Accepted Solution

by:
vijay4sql earned 2000 total points
ID: 16882179
Yes but only if you are sure that they do not correspond to ur current publication.

thx
VJ
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question