• A trigger will do this, or you can read the log later if you buy a tool.

    http://www.sqlservercentral.com/articles/Security/sqlserverauditingpart1/1451/