Thank you all for your feedback!

Sam - Thanks for your Code...

I just want to see the space used by a process or session against TempDB space.

i.e. For example. TempDB space used...

I faced same timeout error even for Select Query in VB.net.  I used command object to resolve the issue. Using command object you can set Command Timeout to our need (in...

Yes...The script posted by Michel has resulted the proper output i could capture the exact used space. The used space floats up and down when insert some data into #temp...

Hi Jiff and Phill,

Yes you are right..we use lots of cursor and #temp tables in our weekend jobs because basically ours is dataware house related project we suppose dump data...