>>>Thanks
>>
>>Until the connection closes that created it or until you explicitly drop it with DROP command. (Or, of course, if SQL Server is re-started and TempDB re-created).
>
>Ok
>
>I'm running a stored procedure in management studio selecting data into #new_member_list
>If I then try to select from #new_member_list I get Invalid object name '#new_member_list'.
>
>I know my stored proedure is selecting data as if I select into a table I get results.
>
>So what do you think I might be getting wrong.
>
>Thanks
If you created a temp table in SP, you can not access this temp table outside the SP. If you want to access it from outside, you need to create it before calling this SP, then this table will be visible in the SP and you can populate it there.
I suggest to also read this excellent article
How to share data between stored procedures
If it's not broken, fix it until it is.
My Blog