title: Determine protocol of a given sql connection
body: <p>I'm trying to see what connection protocol a given connection to sql 2008 is using (be it shared memory, named pipes, or tcp/ip)...I'm not seeing this info in the sql activity monitor. Is there some place I can view this?</p>