as i couldn't find my temptable ##TMP table
i created a new one - not within the SP- that got display in the : Databases -> System Databases -> tempdb -> temporary Tables.
I didn't think that the ##TMP table already exists. But it should have been created after i added "INTO ##myTempTable" to my SP.
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.