How to get a list of global temporary tables in the current database?
For SQL Server 2005+, all global temp tables (tables that are created with a ## prefix) will be found in tempdb.  This should work for you:

SELECT * FROM tempdb.sys.tables
WHERE name LIKE '##%'