You can use a subset_filter clause that goes something like this ... @subset_filterclause = N'Upper(SomeTable.TerminalID) = Upper(Host_Name())

Merge replication is likely the best candidate for the scenario you describe. I suggest you read everything about merge replication you can find in Books-On-Line, MSDN, etc. Merge replication is...

Check to see if there is a constraint on rowguid. Also, I believe there will be an index pointing to rowguid, which will need to be deleted.

Also, if you try...

You can add new columns to a replicated table by using the sp_repladdcolumn system stored procedure (see BOL for details). You could then update the production server with the info...

This is puzzling. I have never heard of an agent just disappearing unless someone had deleted them.

What version of SQL Server are you using? Also, you say you are changing the structure, so are you just adding new columns to a table?

Are you sure you are logged in as an admin? You won't be able to see the agents if you are not an admin.

To run effeciently, SQL uses as much memory as possible for cacheing, etc. SQL is designed to give back memory as other apps need memory.

Is the distributor on the same server as the publisher? If not, then you will have to give 'distributor_admin' logon rights on the remote distributor. You can use either a...

They will not be able to start replication unless they have administrator rights. As an alternative, you could set up the replication agent to start every one minute. That way...

I believe you will need to disable the replication on the old server, move the database to the new server and re-establish replication on the new server.

In the Enterprise Manage go to Tools ==> Replication ==> Disable Publishing

see if this link helps:

http://support.microsoft.com/default.aspx?scid=kb;en-us;811028

This KB article "might" help.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q303287

You can handle smaller amounts of data like this, but for the large amounts you are talking about see the BOL topic "Retrieving ntext, text, or image Values".