Assuming that you don't mean to record the information yourself, but want SQL server to do it for you, have a look here:
Auditing in SQL Server 2008[
^] - it may not be exactly what you want to know, but it shoudl at least get you up to speed with want questions you need at ask!