The suggestion from cmille19 sounds interesting and should at least kill the connection above the limit that I specify. Will write a script...

I have the developers put into a role which is assigned the SELECT for tables only. However, that too put the tables into a LOCK situation when new members are...

Yes, I have been monitoring using this method in a SQL job and thus realizing that the tempdb is growing. My objective is to know which store procedure is causing this...