Antony Symonds (8/15/2012)

---

Hi All,

So my subscriber server had a crash the other day...

The result of which meant that some row inserts didnt get replicated to the subscriber...

Replication is working fine going forward.. but I have these missing rows..

example : tbl_asn @ subscriber has 400 records tbl_asn at publisher has 402.

I have run tablediff and generated a script(see at end of message)

If I run this at the subscriber(where it is missing) I assume it will attempt to replicate this back to the publisher(where it exists)

My question is : Will this cause replication to fall over or will it just go "oh well its there, these arent the records you're looking for, go about your business, move along" and be happy?

Thanks

Antony

SET IDENTITY_INSERT [dbo].[tbl_asn] ON

INSERT INTO [dbo].[tbl_asn] ([asn_bulkOrder],[asn_busyFlag],[asn_Count],[asn_date],[asn_guid],[asn_id],[asn_order],[asn_Sent],[rowguid]) VALUES (1370218,0,1,N'2012-08-14 12:34:22.677','Null',112949,8002925,0,'a1f2f2f7-03e6-e111-a20f-001e4f2031f5')

INSERT INTO [dbo].[tbl_asn] ([asn_bulkOrder],[asn_busyFlag],[asn_Count],[asn_date],[asn_guid],[asn_id],[asn_order],[asn_Sent],[rowguid]) VALUES (1371103,0,1,N'2012-08-14 12:34:23.350','Null',112951,8002927,0,'3b67edfd-03e6-e111-a20f-001e4f2031f5')

SET IDENTITY_INSERT [dbo].[tbl_asn] OFF