Sri8143 (8/11/2014)
Hi,There are multiple temp tables with different suffix in the tempdb which i cant drop or delete it as it is from a different session which is not active anymore.. I believe those temp tables are being created as part of a stored procedure which is being executed by sql agent job which is failing half way through so that it is never being dropped ..How to handle or reduce the size of the tempdb.
Yes, we will fix the rootcause but how do we get the data back or get rid of those tables ?
Are those sessions logged off or just "inactive" on the SQL Server Instance? I believe the temp tables will stay until sessions are closed. (or Killed but might be risky to do :w00t: ) You wont have permission to drop them.
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀