Bob,

Good points and I'll try to remember to clarify a bit. I usually do post a "why do you want this. Perhaps we have another solution" with my query.

I don't have the list handy, but Configuration Manager grants the rights needed (folders/files/user rights) for the service account.

Always ask what they want to do. They often don't know the problem.

Third vote for Jeff/Gail

http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/vcspart3/525/

SQLPackager from Red Gate works as well

Change this in Configuration manager, not control panel, and you should be fine.

I'd go with auditing. Trace/Profiler could miss something if it gets stopped, or isn't started when the server reboots

I'd go with Gus' advice.

create new table

begin tran

select into from old table (minus GUID)

drop old table

rename new table

commit

What you would need to do is serialize these. So backup, then script the move, then backup next one, etc. You'd need validation to be sure that the backup was...

Are you executing through BIDS? sp_start_job? How?

http://searchenterpriselinux.techtarget.com/tip/0,289483,sid39_gci1207179,00.html\

http://www.isql.org/2007/02/mysql-vs-sybase-ms-sql-server.html

How are you executing the package?

If it needs Windows auth, you need to call it from an account that uses Windows auth or there are no credentials.

SQLSentry has a great tool for scheduling stuff across servers and managing the process.

SQL Agent works well, however, might not be the best choice here. Windows Scheduler works, but doesn't...

What are you trying to achieve? Perhaps we can suggest something. Replication doesn't necessarily seem to fit what you are asking.

You can learn a lot from reading about this, but that won't necessarily get you to think about everything. This is a complex subject, and a lot of moving to...