<div>
I wouldn't post it for such a low bonus, but you answered at least one question before. Good luck in further investigation.
</div>


I wouldn't post it for such a low bonus, but you answered at least one question before. Good luck in further investigation.

<div>
That's amazing..and it did exactly what I needed. &nbsp;Thanks!
</div>


That's amazing..and it did exactly what I needed.  Thanks!

<div>
<div class="content wysiwyg-content">
I have a database that I need to clean about half of the records out of because a client is selling off half of his company. &nbsp; The whole thing is a huge mess of tables with various dependencies all over the place. &nbsp;I need to know if anyone knows of a script that can be run or an option that can be set to automatically allow cascading delete for every relationship in the entire database. &nbsp;Thanks! &nbsp;I'd make this worth more points, but I'm new and that's all I've got.
</div>
</div>


I have a database that I need to clean about half of the records out of because a client is selling off half of his company.   The whole thing is a huge mess of tables with various dependencies all over the place.  I need to know if anyone knows of a script that can be run or an option that can be set to automatically allow cascading delete for every relationship in the entire database.  Thanks!  I'd make this worth more points, but I'm new and that's all I've got.

Cascading Delete for every relationship in a database

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.