You might try dbcc opentran. We ran into a vendor package that was leaving open transactions in tempdb. In our case it was the log that had humungous growth rather...
There is something of an inverse correlation between the number of knowledgable dba's and knowledgable programmers when it comes to rdbms's. We have less of the latter and try to...