I got the above error when I tried to execute the following query
delete from BUSINESS_ASSOCIATE
where ba_name is null
As you can see the query isn't exactly complicated.
What the table does have is lots of dependancies. I got SSMS to show me all the dependancies and there are literally hundreds (maybe thousands - I am not going to count them all) of dependant tables and i suspect that is what is causing the problem.
So what do I do about it This is a valid data-model (industry standard in fact) but SQL won't let me delete data from this table and that is a huge problem for me. Any advice about how to progress would be welcomed.