Here’s another use for the information captured by the default trace.  Ever wonder what session created the tables that exist in tempdb?  Well you can find it using the default trace and the sys.objects view in tempdb.  Any time an object is created in a database, EventClass 46 (Object:Created) is captured in the trace output of the ...