• If I understand what you are saying, you are looking for an audit trail of what has heppened in your database? There is no log per se. There is a default trace, which has a lot, but it is also limited in size, so the time in which things are stored is relatively short, depending on load.

    http://www.sqlservercentral.com/articles/64547/