> But I am not sure if this will have a negative effect on the > database and the relationships between the tables. Will there > be remnants of this event in other tables? > Does anyone have any experience of this? > Any help would be much appreciated,
There are other tables involved. Referential integrity checking will prevent you from doing the delete on the events table until you get rid of the data in the related tables. Pseudo SQL code to do this below. Variation of my routine data purge job I've posted before. ------------------ SELECT eventid INTO #tempevents FROM events WHERE <Your conditions> DELETE eventrawdata FROM eventrawdata INNER JOIN #tempevents ON eventrawdata.eventid = #tempevents.eventid DELETE eventupdates FROM eventupdates INNER JOIN #tempevents ON eventupdates.eventid = #tempevents.eventid DELETE eventparams FROM eventparams INNER JOIN #tempevents ON eventparams.eventid = #tempevents.eventid DELETE eventresponse FROM eventresponse INNER JOIN #tempevents ON eventresponse.eventid = #tempevents.eventid DELETE FROM events WHERE <Your conditions> DROP TABLE #tempevents SELECT remoteeventid INTO #tempeventsrejected FROM eventsrejected WHERE <your conditions> DELETE eventupdatesrejected FROM eventupdatesrejected INNER JOIN #tempeventsrejected ON eventupdatesrejected.remoteeventid = #tempeventsrejected.remoteeventid DELETE eventparamsrejected FROM eventparamsrejected INNER JOIN #tempeventsrejected ON eventparamsrejected.remoteeventid = #tempeventsrejected.remoteeventid DELETE eventresponserejected FROM eventresponserejected INNER JOIN #tempeventsrejected ON eventresponserejected.remoteeventid = #tempeventsrejected.remoteeventid DELETE FROM eventsrejected WHERE <Your conditions> DROP TABLE #tempeventsrejected ------------------- You should also be able to do this using a "DELETE FROM <table> WHERE eventid IN (SELECT * FROM #tempevents)" but I think when I've tried that, the performance *seemed* worse but I never did measure the performance so I can't say that with any confidence. Mike Lyman Incident Response _______________________________________________ ISSForum mailing list [EMAIL PROTECTED] TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo
