We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SELECT 1 AS a INTO #tmp;
GO
DROP TABLE tempdb..#tmp;

SELECT 1 AS a INTO #tmp
GO
DROP TABLE tempdb.dbo.#tmp

SELECT 1 AS a INTO #tmp
GO
SELECT * FROM tempdb..#tmp
-- look in messages tab