PDA

View Full Version : Delete records from table with dependencies


dominicall
10-20-2002, 07:40 PM
Hello all

Am having a slight problem...

I have a table in a SQL2000 database called 'tbl_Towns' that has 15 dependencies in stored procedures.

I have a new and updated dataset for this table. I want to replace the existing data with the new data.

My problem is that whenever I try to delete the existing data the delete statement is terminated because of a conflict with the stored procedures.

Anyone tell me how I delete the data and replace with the new data without the conflict???

Thanks

Dominic :confused:

dominicall
10-20-2002, 08:24 PM
Sorted it :)

raf
10-21-2002, 02:26 PM
a real credit to your signiture :

dominicall - confusing himself more and more each day

dominicall
10-21-2002, 05:28 PM
LOL - thanks raf.

Thought it was appropriate at the time.

Dominic