• FYI, there is a nice routine I put on a couple of my servers that logs information like this so you don't have to worry about stuff falling out of the default trace. It works on SQL 2008 and 2005, although the 2005 version doesn't capture as much info.

    http://www.sqlservercentral.com/Forums/Topic947481-391-1.aspx

    Shaun