While it is running, look for tables in tempdb:

SELECT * FROM TempDB..Sysobjects WHERE Type = 'u'

A table variable usually has to get pretty big before it spills over into TempDB.