On Sat, 25 Sep 2004 11:55:47 +1000, Michael Kear <[EMAIL PROTECTED]> wrote:
> I'm using SQLServer2000, and whenever I copy the production databases to my
> local server to use as testing databases, the DTS doesn't copy the default
> settings
You need to select "copy objects and data" rather than "copy tables" -
I think Sandy already posted that. The other thing I've found is that
I usually need to have the same username - with the same password and
the same permissions - on the destination database as the source
database.
HTH,
K.
--
Kay Smoljak
http://kay.smoljak.com/
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
