yes but wat i m staying here is

there is a procedure in which there are around 30 more procedure which are getting called

Eg create procedure abcdef

(

begin

exec ab ---doing some operations creatin 5 temp table doing some updation,insertion etc

exec abc ---doing some operations creatin 5 temp table doing some updation,insertion etc

exec abe ---doing some operations creatin 5 temp table doing some updation,insertion etc

exec abd ---doing some operations creatin 5 temp table doing some updation,insertion etc

end

)

what i know that after the procedure is exec the temp tables gets destroyed from the tempdb.

but here in this senario the temp tables are not getting getting destroyed from tempdb.

they are getting dropped wen the abcdef procedure gets executed completly.

Also wen we r running this procedure from different session we are getting blocking on tempdb

while creating a temp tables within the procedures