Try this:

in one query window, run:

CREATE TABLE #testvm (RowID INT IDENTITY);

In a different query window, run your command:

IF EXISTS (select * from tempdb..sysobjects where name like '%#testvm%') SELECT * FROM #testvm

As you will notice, your query does find a temp table - however you can't use it since it was created in another session.