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!: http://ask.sqlservercentral.com/questions/21094/how-to-find-which-user-dropped-a-table-in-a-database