Problem deleting a record from a SQL 2005 parent table
I have a parent table with several child tables. If I try to delete a record from the parent table I get the error message "Unable to delete the "parent table name" record because it is being referenced by "child table 1 name". This makes sense. What doesn't make sense is when I delete the record from "child table 1 name" and then attempt to delete the "parent table name" record I get the exact same error. I swear the record no longer exists in child table 1. Is there something that needs updating in the parent table? If I restart SQL will that help?
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!