• I am using SQL 2005 not SQL server 2012. Moreover, I shrinked as much as I can. At last after clients approval we have restarted services and it clears the space from TempDB. But i am very much disapointed as I am not able to find out exact culprit of the issue. Might be the SP that I attached in the previous post of mine but not sure.;-).

    If anyone have good knowledge of SP Or scripting pls review the SP I attached and let me know if it creating TempDB to use more Disk space.