Thank this author by sharing:
By Man inTheMiddle,
Identify orphaned records in a datebase.
You may use this script to indetify orphaned record in a database.
This script generate some sql queries that can help you to take a decision regarding orphaned records.
Best regards,Lungeanu Adrian-Liviu
Trigger logic to avoid orphaned records in a many-to-many detail table
Fix Orphan Users (SQL 2K5 & 2K)
Learn about orphaned distribution transactions in SQL Server and how you can clear them.
Records in msdb..backupset for DBs that have been dropped
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.