LinkedIn | FaceBook | Twitter
The new Activity Monitor has another trick up its sleeve: If you open it and then expand the first band of information just below the four graphs, you'll see a list of processes that you can order, sort and filter. If you right-click any process, you'll see an option to "open in Profiler". Click that, and you'll open Profiler with a default trace right on that SPID. Very useful to quickly identify the actions of a connection.
PingBack from http://mstechnews.info/2008/10/opening-sql-server-profiler-from-ssms/
There's also the option to set a trace on the current query window (that is, current SPID) through the context menu - however, it doesn't look like the events/columns picked automatically are related to the default trace template. Is there a way to configure this trace's events and columns?