I have a SQL Server Express database which I need to synchronize with two or more occasionally connected computers. The primary keys in all but one of the tables is a uniqueidentifier. I have set one foreign key constraint and one relation. The parent-child form works well until I try to insert a new record. Then I get an error because the newid() default on the uniqueidentifier field doesn't seem to work properly. I have found a work around (on E-E) using stored procedures with the tableadapter. Unfortunately, the wizard option for generating stored procedures is either grayed out or does not exist, depending on how I go about trying to modify (or create) the tableadapter. So --
1. How does one add the stored procedure to a tableadapter? If I create the stored procedures on the server version, will they synchronize to the replica (or vice-versa) or must I create them separately on the two databases?
2. Is there something special to do with child tables?
3. If I can't do it with stored procedures, is there a better way? I have tried generating a new GUID to insert into the detail view textbox but haven't gotten it to work. I have not tried generating a new GUID for the datagridview column which is the next challenge.