Tag: default trace

  • Recent Objects – Without Triggers

    I was thinking about writing a script to capture the objects that were either CREATED/DELETED or MODIFIED in the last 24hrs. Instead of directly querying the sys.objects I from where I can only get minimal information I decided to get a whole bunch of useful information using the SQL Server default trace. By default the…

  • SQL Server 2005 Default trace

    The Default Trace is implemented to audit certain events in the system. To verify if the default trace is running, run following query: