Am using the DeleteCIType_Versionable.sql script to clear down config items prior to loading the spreadsheets onto the live system.
All was going fine until I tried it on Radios. I got the error message "The DELETE statement conflicted with the REFERENCE constraint "fkey$cm_change$ci". The conflict occurred in database "LDSD_OOTB", table "dbo.cm_change", column 'cm_config_item_guid'."
When trying the import my log file is full of error messages
"28/03/2012 13:19:20 : Cannot insert duplicate key row in object 'dbo.cf_config_item' with unique index 'index$cf_config_item$title'. The statement has been terminated."
Anyone any ideas of what I need to change to get this to run for these items.
That sure sounds like you have data that is using that CI item still. Can't delete a CI if you have a Change Control (or anything else) that links to the CI. You might try clearing other tables 1st and then come back to this last.