I am trying to delete records from a child table when records from the subsection table are deleted. I am getting errors with this, but I am not sure why. Or what I am doing wrong. This seems like is should be easy enough.
CREATE Trigger RemoveSubSectionChildren
INSTEAD OF Delete
DELETE FROM [Content]
WHERE [Content].ContentID = Deleted.ContentID
DELETE FROM SubSection
WHERE SubSectionID = Deleted.SubSectionID