The temporary tables are the tables which will be created in the tempdb of the database. If u have so many temporary tables in the procedure then it will fill the tempdb's allocated space. If the tempdb is full then u may have to restart your system. Moreever if ur using the temporary table and access it paralelly then the tempdb will get locked until the completion of the request of a particular user. So I may cause the performance problem even...