When using DTS to copy Tables/Views from one SQL to another, some of the
tables/views start to copy but error out.

Is there anyway to fix/rebuild the existing tables/views before copying or
worst, is there anyway to let as many copy before it fails. I understand
this would not get me a complete set but if I can't do the above, I need
something to move forward with.

Try using bcp instead. However, If the database is suspect,
you may not be able to get all the data out.
The best thing to do with suspect databases is to restore
after you have determined what has caused the database to go
suspect.

-Sue

On Sun, 27 Mar 2005 07:15:01 -0800, khcrookie
<khcrookie (AT) discussions (DOT) microsoft.com> wrote:

Is it possible to bcp individual tables from SQL mdf to another SQL mdf or
does it have to write them to a .txt file, then import them into the 2nd SQL
mdf ?

"Sue Hoegemeier" wrote:

When you bcp out your data, you are copying it from a table
or view to a file. Then you would import the bcp file into
the other database.
You can find information on using bcp in books online under:
bcp Utility

-Sue

On Mon, 28 Mar 2005 09:23:04 -0800, khcrookie
<khcrookie (AT) discussions (DOT) microsoft.com> wrote: