TableAdapter Call Stored Procedure using Temp Table Error

when using tableadapter with Stored Procedure visual studio throw exception can’t find object #table

solution is in SP

SET FMTONLY OFF;