Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
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
Fix Orphan Users (SQL 2K5 & 2K)
Learn about orphaned distribution transactions in SQL Server and how you can clear them.