All,
Is there a tool that I can use to figure out where a db table is being locked at? I'm perplexed by this...I'm using SQL Server 2000, against my will, and well, I have a couple of connections being blocked by others, of which I would like to trace back to my source code...any thoughts or ideas?
The Enterprise Manager for SQL Server only tells me which processes are being blocked and by which client, but, I need to find the areas in the code which are not releasing the connections.
