Post reply

How to track an activity

  • August 1, 2019 at 7:05 pm

    #3668028

    If the trace hasn't rolled over from when it happened, you could query the trace files or just do the Schema Changes History report for the database.

    Sue

  • August 1, 2019 at 7:48 pm

    #3668035

    Thanks for the reply, I did not set a trace, unless you are telling me that there is one internally set that I do not know of?

    How would I query for this?

    Thank you

  • August 1, 2019 at 8:08 pm

    #3668040

    There is a default trace that runs. It's enabled by default and if you didn't know about it, it likely is still enabled. The Schema Changes History report queries the default trace files. You can execute queries against the files using sys.fn_trace_gettable. There are quite a few examples in the following (as well as some other info on the default trace):

    The default trace in SQL Server – the power of performance and security auditing

    Sue

  • August 1, 2019 at 8:40 pm

    #3668055

    Thanks I really appreciate the help.

    Thank you

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply