Without triggers it is not very easy. Triggers can meet your exact requirement.

As you mentioned you can use Profiler tool which is UI based Tool but again you cannot query without saving them to table, moreover you cannot get old value.

Contact me at bmlakhani@yahoo.com (Messenger) for further questions,