You can query the sys.dm_os_performance_counters for object name = SQLServer:Memory Manager.
It will give you Total Server Memory that SQL is using and Target Server Memory.
Raymond Laubert
Exceptional DBA of 2009 Finalist
MCT, MCDBA, MCITP:SQL 2005 Admin,
MCSE, OCP:10g