Right but you will still have to syncronize all the subscribers, so I don't see much difference in effort.

When applying the snapshot you can specify what to re create at the subscribers...tables, pkeys, indexes, fk.

You can manully add the relationships when creating the subscriber db, or you can...

You should check that you have the subscriber checked in the publisher as a subscriber.

In the distributor properties, add the subscriber in the subscribers tab. If you can't find it,...

Yes, but only if you drop the publication and after altering your table, re create the publication again.

Agree. Merge would be the best for you.

There is no problem in setting the distributor in the same server that the subscriber and the publisher, so you should't have any problem. I would run the wizard to...

You can run the sp_trace* SPs within a job.

You don't need to specify the server or any table, so you only have to specify what to trace and you can...

You could check one of this site sponsors, at http://www.sqllitespeed.com

Can you tell us what type of conflict resolver are you using and how you configured your replication?

Can you tell us what type of conflict resolver are you using and how you configured your replication?

Remember that temp tables are only local to the current connection. You DTS could be opening more than one connection, or just can't access the temp table.

Try creating global tables...

You can't. But you can drop the subscription of any subscriber to only that table.

But the table will still be part of the publication, so top drop it you need...

Is the name of the server the same as the SQL instance you found?

agree..but the next time you start the log reader agent, it will read all the transactions and commands made when it was stopped.

No, you can't fire the trigger with replication during initial snapshot. But since it is a one time process, once the snapshot is applied, you can manually re-insert all the...