Deleted 3.3 million records, and now replication hung

I deleted 3.3 million records out of a table on the distributor. They
merged correctly to one subscriber but the other two aren't getting the
deletes. Since the only deletions on that table would be the ones I did,
can I run the following with no adverse effects:
delete from msmerge_tombstone
where tablenick in (select nickname from sysmergearticles where
tablenick=nickname and name='MyTable') and
rowguid not in (select aud_rowguid from MyTable where
aud_rowguid=rowguid)
Darin
*** Sent via Developersdex http://www.codecomments.com ***
While you could do this it is not advisable as you will run into problems
later on down the road. I would drop the subscribers, do the delete and then
redeploy the subscriber(s).
http://www.zetainteractive.com - Shift Happens!
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
"Darin" <darin_nospam@.nospamever> wrote in message
news:%232dmt9pLIHA.4228@.TK2MSFTNGP02.phx.gbl...
>I deleted 3.3 million records out of a table on the distributor. They
> merged correctly to one subscriber but the other two aren't getting the
> deletes. Since the only deletions on that table would be the ones I did,
> can I run the following with no adverse effects:
> delete from msmerge_tombstone
> where tablenick in (select nickname from sysmergearticles where
> tablenick=nickname and name='MyTable') and
> rowguid not in (select aud_rowguid from MyTable where
> aud_rowguid=rowguid)
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***