No problems using Merge Replication with SP4 installed.

you're welcome

You can set the FK's to use the "Not for Replication" option.  This will prevent the FK errors (referential integrity) during replication since replication moves the data in batch's.  It...

ERWIN data modeler is the "best" product.  It's expensive and may be overkill for what you're trying to accomplish.

Use Merge Replication

Both sites can continue working if there is a communication breakdown.  Transactions are written to replication tables/conflict tables.

In the "Snapshot Properties", there is an expiration setting for dropping...

Consider writing many small sprocs which are called from 1 main sproc.  This way you still have the flexibility of isolating the individual functions (as mentioned above), but you will...

post the DDL of the 2 related tables

Concatenated PK's are sometimes necessary.  Before I comment more, I too would like to see the example you're talking about.

You cannot convert a default instance to a named instance.  You will need to create a new named instance, as previously mentioned. 

Yes, you would detach/attach from the default instance to...

I posted in your other thread

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=234505

You'll need to use the SQL

CASE

or

COALESCE

to replace Oracle DECODE

You'll want to use the IMAGE datatype.

Note:  We have an on-going project where we are either creating or uploading pdf's.  Prior to this project starting we conducted research as to the...

According to the BOL, the sp_start_job will accept @job_name or @Job_id.  I have been using @Job_Name as the parameter to pass.

set @Job_Name = (select name from sysjobs where name like...

1.  Snapshot won't create the guid as a erroneously stated, the merge replication will, which I think you may have mentioned for earlier in the thread about 2 other prod...

1.  I actually have a job that starts replication, if it has stopped.  We are running the agent continuously, but essentially I use this sproc:

EXEC @ERR = sp_start_job @job_name = @JOB_NAME

I...