"I've found replication to be a bit unreliable"  If you stick to the rules, it works quite well.

1) Partial Replication - I think this would be nightmare to keep...

No matter which mode, Log Shipping needs exclusive use of the database to load the logs so users can't be connected at that time.

Putting the distributer on a different...

Transactional Replication won't add or change anything in the database but it does require that the tables being replicated have a primary key.

It will also install a Distribution database...

I think you will also need to give the user IMPERSONATE permission although it looks like you are connecting as NewUser1. If that is the case you would Execute As...

http://www.microsoft.com/technet/scriptcenter/sgwho.mspx

This is a link to the script center at MS. It has links to script blogs, etc. You might find your answer there.

DTS samples the first 8 (I think) rows and sets its' buffer size based on that sampling. I don't remember exactly where it is (I don't use DTS very often),...

David is correct - the only thing that would come back is an error.

SSIS has a "Transfer SQL Server Objects" task that is similar.

I've used this utility that I found in an article on this site:

http://www.sqlservercentral.com/columnists/cmiller/dumpsqlpermissions.asp

It works quite well

Try a check constraint at the column level. I believe Express supports it.

I'm not very familiar with the way DTS packages are stored in the table but I know they can be saved to a VB file which is plain text. You...

#2 - No, but you can still use QA (isqlw.exe) on 2K5 (at least for the time being)

I've run into a similar issue and from what I have found, IIS (5.0 or later) needs to be installed prior to installing RS. I haven't tried it yet as...

What really gets my goat is the fact that business and congress either don't see or are ignoring the fact that it is the middle class in this country that makes...

once you start a transaction, the DTC is engaged. Be sure that DTC is installed and running.