Glad that worked for you. Is sp_msforeachtable a sproc of your own, or is that a system sproc?
>I ended-up dropping all constraints, then re-establishing them:
>
>
>
>Print 'Disabling all Constraints'
>GO
>sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT ALL"
>GO
>
>-- code to delete records
>
>Print 'Enabling all Constraints'
>GO
>sp_msforeachtable "ALTER TABLE ? CHECK CONSTRAINT ALL"
>GO
Chris McCandless
Red Sky Software