coping databases

#1

If I cannot copy the dt stored procedures when using the
copy db task in dts to copy databases, how do I copy these
dt store procedures? I believe every db needs to have the
dt stored procedures, correct?

#2

I believe they get created when the db itself is created. What ever it is
that creates them will take care of it<g>. It shouldn't be something you
have to deal with.

--

Andrew J. Kelly
SQL Server MVP

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

Quote:

If I cannot copy the dt stored procedures when using the
copy db task in dts to copy databases, how do I copy these
dt store procedures? I believe every db needs to have the
dt stored procedures, correct?

#3

That is what I thought. But for some reason it's not
happening. thank you.

Quote:

-----Original Message-----
I believe they get created when the db itself is
created. What ever it is
that creates them will take care of it<g>. It shouldn't
be something you
have to deal with.

--

Andrew J. Kelly
SQL Server MVP

"Olivia" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message
news:fb6601c3f1c2$e0aefe20$a501280a (AT) phx (DOT) gbl...
If I cannot copy the dt stored procedures when using the
copy db task in dts to copy databases, how do I copy
these
dt store procedures? I believe every db needs to have
the
dt stored procedures, correct?

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

coping databases

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

coping databases - 02-12-2004 , 05:49 PM

Re: coping databases - 02-12-2004 , 06:32 PM

Re: coping databases - 02-13-2004 , 03:19 PM