How? Seeing who made the most recent modification to a row wouldn't tell you who made the change you were interested in...
Also used audit trail logs (populated via triggers that accessed old value/new value via the INSERTED/DELETED tables)....but in this case, the information in the core table was sufficient.