depending on your version of sql2008 there is a audit function available to do that

there is also a trigger that will do that too