Absolutely, if the trigger is not there you will get the error

Make sure the Distributor is using the correct account!  

you are welcome

To be in control of the column order you 'need' format files

data conversion error are usually asociated with missalignment between the Files and the Columns on the Tables.

Are you using format files? If you are you are going to have to...

You are missing the : on the path 'E:\data\testdot_log.ldf'

Is your collation case sensitive?

It seems like is the only file with lowercase 'data' instead of 'Data'.

You are on the right track!

Have a look http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/dataset_server_ce.asp

MSDE can't be used as Publisher or Distributor of Transactional Replication!

Cheers,

exec sp_MSforeachtable 'Alter table ? nocheck constraints all'

-- do your bcp stuff

exec sp_MSforeachtable 'Alter table ? check constraints all'

keep in mind that at this point you are on your own...

Because the only "correct" way of doing it is exactly what you described and you will be having some hard time with the scripts to do it, the safest way...

Definitely is wiser to separate them into several jobs and also to space them. That, will give you:

• Ability to balance the load imposed on the server
• In case you need to shorten...

What Error is reported when it fails?

Hopefully your Production Hardware is  better than your desktop

As an example of how Peer-to-Peer does NOT guarranties 100% availability, this is what BOL has to say:

Maintenance Considerations