I'm not sure that this is perfect, but you can look at sys.dm_exec_sessions which has a memory_usage column that shows the # of 8KB pages used by the session.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question