Is there a simple way to do a full SQL Server instance
move to another server: all DBs, DTS packages, Jobs &
other Management functions, Replication, Security, ...?

On the DTS packages - ours have a server name coded into
the DB connections. If moved to ServerB, will all the
ServerA connections be automagically changed to ServerB,
or do we have to change them all by hand?

You may want to check out the following site for information and a utility
to transfer them

http://www.sqldts.com/default.aspx?6,105,204,0,1

John

"glennf" <gfroemming (AT) primewire (DOT) com> wrote