sql server replication: Hi All

I have a problem:
When I created merge replication, system tables , named like aonflict%, conflict%, conflict%... (% is a string) , also were created. Now I disable replication and I want drop these tables. I can not drop them. How can I drop these tables

Many thanks for help

Nguyen Quang Th

try this

DECLARE @name nvarchar(129)
DECLARE list_conflict_tables CURSOR FOR
SELECT name From sysobjects WHERE type='u' and name
like '_onflict%'

OPEN list_conflict_tables

FETCH NEXT FROM list_conflict_tables INTO @name
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT 'dropping conflict_tables ' +@name
select @name='drop Table ' + @name
--EXEC sp_executesql @name
print @name
FETCH NEXT FROM list_conflict_tables INTO @name
END

CLOSE list_conflict_tables
DEALLOCATE list_conflict_tables

GO
This will print the list of conflict tables. make sure
that none of your user tables are in this list and then
uncomment the ' --EXEC sp_executesql @name' section.


[quoted text, click to view]
like aonflict%, conflict%, conflict%... (% is a string) ,
also were created. Now I disable replication and I want
drop these tables. I can not drop them. How can I drop
these tables.
[quoted text, click to view]