How can I check the integrity of disabled foreign key relationships for each individual table? (SQL Server 2008)
These DBCC CHECKCONSTRAINTS commands can be run as follows:


DBCC CHECKCONSTRAINTS (TableName) - checks an individual table
DBCC CHECKCONSTRAINTS (ConstraintName) - checks an individual
constraint
DBCC CHECKCONSTRAINTS WITH ALL_CONSTRAINTS - checks all constraints
in the database
DBCC CHECKCONSTRAINTS WITH ALL_ERRORMSGS - returns all rows that
violate constraints
DBCC CHECKCONSTRAINTS WITH NO_INFOMSGS - suppress messages when query
runs
DBCC CHECKCONSTRAINTS check only enabled constraints


Keep in mind that SQL Server needs to read through all of your data to check for the constraints, so be careful not to run this across the board for your large or very busy databases. This should be something that is run off hours and also for very large databases you should run this either at a table level or a constraint level.