Hi,

I think you are situation is something like this if you are using SQL 2005 or 2008....

http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/%5B/u%5D

As Jack said the default trace is a valuable tool for DBA's. It minimally impacts the system performance and will give you information about auditing events, database events and any errors....this is an awesome article by Adam Haines....

Please go through the above article....

cheers!!!