If you want something more advanced you need to build the mechanism yourself. Generally you don't want to log everything, just specific data changes, so it's fairly easy to create log tables and maintain them through the same stored procedures that are performing the data changes.