barry555's script is just a starting point, it does not consider foreign keys on multiple columns, or several relations between two tables, it will mostly give wrong results

i found a better...

try debugging from .NET ide, it worked for me

if .NET does not debug then connect the database in question from enterprise manager and then again attempt to debug using .NET....

loop thru all the sysprocesses for your db_id and kill them, except dont kill your own process,

and then check if there are any new processes to be killed if...

This is a must-have for any DBA, so I'am attempting to join the tables

sysindexes

sysindexkeys

sysforeignkeys

sysobjects

to arrive at a elegant and efficient solution.