Syncronizing Table Primary Keys over WCF RRS feed

  • Question

  • I have two syncronized tables over a WCF.  Someone can insert a value on either side of the WCF.  The key is set by NEXTSEQUENTIALID().  If they set the value on the table on one side, it must be updated on the other with the same values.  I need to be able to basically modify a db generated column, or if its Guid.Empty, I want the DB to set the default value.  Any ideas?


    Monday, May 3, 2010 3:30 PM