System proc in master db
>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
Al Williams
Anola MB, CANADA