dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Express 32 bit import export wiz insists on dropping tables - sqlserver-tools

This is a discussion on Express 32 bit import export wiz insists on dropping tables - sqlserver-tools ; 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 ...


Home > Database Forum > Microsoft SQL Server > sqlserver-tools > Express 32 bit import export wiz insists on dropping tables

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 11-13-2008, 07:16 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Express 32 bit import export wiz insists on dropping tables

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



All times are GMT -4. The time now is 10:11 AM.