Try using dbcc checkconstraints with all_constraints . It should return all
'bad' data in the database...

MC



"Dmitri Shvetsov" <dshvetsov@cox.net> wrote in message
news:Xzlnb.87999$Ms2.54382@fed1read03...
> Hi,
>
> What methods can we use to check the integrity problems? Some records in
my
> database are having Foreign Keys but the database doesn't have any related
> records with required Primary Keys. I need to scan the whole database and
> delete (maybe with backup, maybe not) all wrong records.
>
> Who can I do that? Is it need to write my own application to do that or we
> have some standard way to fix these problems? I'm not a database
> administrator and don't know these ways (yet). Can somebody help me with
> advice?
>
> Thanks.
>
> Dmitri Shvetsov
>
>
>
>