Long story short is i want to be able to shrink tempdb and release the memory from disk. There are many ways to do this, but I'm looking for this particular connection that is holding the tempdb from being able to shrink...Thanks.