I have used temp tables and drop the same in the every stored procedure in my database. When I try to check my tempdb data using `Select * from tempdb.sys.tables`, I am getting many tables with names like #A002FF4B,#A08A53F2...etc (name with some hex characters).

These tables are continuously getting added in my tempdb and it is getting full. So sometimes my application stops due to it is not able to access SQL server once tempdb is full.

How can I resolve this issue?