it enables some columns on the sessions or connections dmv, forget which one. MS had a nice script for SQL 2005 SP1 but haven't seen anything for SP2 yet