Before performing data actions:
-- generate these and run SELECT 'ALTER TABLE ' + so.NAME + ' NOCHECK CONSTRAINT ALL' FROM sysobjects so WHERE xtype = 'u'
After performing data actions:
-- generate these and run SELECT 'ALTER TABLE ' + so.NAME + ' CHECK CONSTRAINT ALL' FROM sysobjects so WHERE xtype = 'u'
Thanks to ET for this code bit!
No comments:
Post a Comment