Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Importing data

Author  Topic 

jim_jim
Constraint Violating Yak Guru

306 Posts

Posted - 2010-10-14 : 16:39:32
Hi Guys
I have a table A with clustered primary key on 2 columns and has data in it which is refrenced by some other table B

I have to load fresh data into Table A by deleting the data that exists.I get an error when I try to delete it using import/export

Please advise

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-14 : 16:41:16
Delete the child data first, then the parent. If you need further help, then we'll need more information.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -