Is there any way to figure out the host machine name from where an sql trace was originated or some other details like spid against which the trace is running ?
When I execute the following query -
I get there are two sql traces running ,for the first one I am sure is the default one initiated by the sql server but not sure about the other one.
I am also not able to get any idea when I query the following -
I adopted the following query from @Håkan Winther great script to find "who changed what"
Credit to @Håkan Winther!