dbTalk Databases Forums  

Express 32 bit import export wiz insists on dropping tables

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Express 32 bit import export wiz insists on dropping tables in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ian Michael
 
Posts: n/a

Default Express 32 bit import export wiz insists on dropping tables - 11-13-2008 , 05:16 AM






I have the following situation: Machine with SQL2008 express installed.
Restored Backup from previously existing database of different collation.
Blank database with SQL2008 default collation and all tables and constraints.
I try to "BCP" in the data with the 2008 32 bit data wiz. I have disabled all
the constraints and every time I try to run the wizard I get error - table
object already exists. I have ticked the delete rows and enable identity
insert and unticked the drop table option - seems to have no effect
--
Many thanks in advance

best regards

Ian

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.