Stored Procedure

sp_spaceused sp_msforeachtable 'ALTER TABLE ? CHECK CONSTRAINT all'

DBCC Commands

DBCC CHECKCONSTRAINTS DBCC SHRINKFILE DBCC SHRINKDATABASE