We will probably end up doing one of the replication scenarios.  Thanks for your help.

 Ugh!    I dont think its feasible to split our ERP db up into a federated configuration.  We have a SAN but there are almost 2000 tables with no clear way...

I did submit my post only once. Unfortunately I got three posts.

I think that when you run a job through SQL agent it runs with the permissions of the account that agent is run under.  Go to services and check the...