Before I answer without all of the correct facts, please see the link to a similar discussion below. It's very similar to your situation even though it's dealing with temporary tables.

http://www.sqlservercentral.com/Forums/Topic984394-391-1.aspx#bm984500