A User database couldn't give a hoots about

A) It's name being changed (Unless internally i.e. in a proc, you refer to
its previous name)
B) Being located on a different server.

DTS you should be parameterising everything anyway to plug in to the
package on the other server. It is no different to moving packages between
environments.

Does this answer the Q?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Ric" <Ric (AT) discussions (DOT) microsoft.com> wrote

will be in another. Is there anything that I need to be aware of before the
move? Also, I want to use the same name as the old server. How will SQL
handle a name change? Is there a paticular order I should do this in?