Writing custom event handler would be my first pick. As far as I know there is no OOTB solution for this and most likely this cannot be done by SharePoint designer workflow (I am not very fond of workflows anyway).

Same applies to 2010 version.

Edited:

According to @Lars it can be done with SD so ignore that part of my answer.