<khcrookie@discussions.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:
>
>> 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@discussions.microsoft.com> wrote:
>>
>> >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.
>>
>>