This is a really good write-up about how the timestampe datatype is used in SQL Server:
http://www.pinpub.com/sqlblog/ViewItem.asp?Entry=21