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...

The question is based on identities and defaults. You don't know how many columns, so how can you insert a row? It might seem unclear, but I think it you...

I think you have to reassess how you look at things, do lots of testing, and possibly revisit your architectures. I think this can work. Not that it should, but...

Make sure it's the same on both nodes as well.

It's a round robin type thing.

You can do one file / filegroup and get this granuarity.

Are you talking about paging? There are articles on this site dealing with that.

http://www.sqlservercentral.com/articles/Advanced+Querying/3181/