Getting error Invalid object name '#temp' after selecting table -- select OK, then Profile, and more errors ... Profiling Failed -- Must declare the scalar variable "@LOBCol" ... Database name 'tempdb' ignored, referencing object in tempdb.
It's hard to answer the question based on the information provided. Invalid object name '#temp' implies that you were trying to profile a Temporary table which isn't possible because temporary tables are stored in the system database 'tempdb' and system tables are not a target for Profiling.
I would need more information about what you were trying to profile such as the schema makeup of the table you were try to profile.
Was this any chance a Table Variable?