Viewing 4 posts - 1 through 4 (of 4 total)
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...
July 31, 2006 at 11:25 am
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....
April 28, 2006 at 11:41 am
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...
April 26, 2006 at 12:14 pm
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.
April 25, 2006 at 8:24 am
Viewing 4 posts - 1 through 4 (of 4 total)