Topic: Temporary table removal
Application the client creates the temporary table #z (connection still openly)
After that in management studio, standing in the same I fulfill
select * from tempdb.sys.objects where type ='U'
Also I see there this table #z
To documentation it is written (https://technet.microsoft.com/ru-ru/library/ms177399 (v=sql.105).aspx)
Names of local temporary tables begin with one character (#); they are visible only to current connection of the user
Trouble in that many clients can create simultaneously tables with identical names