A part of a daily DTS package reloads an entire table. Prior to loading, I set the NOCHECK for constraints, using ALTER TABLE tbl1 NOCHECK CONSTRAINT ALL.
However, when the table reloads it contains zero rows. I suspect that the PK constraint prevents the table from loading. When I drop the PK constraint and reload the table, it contains the appropriate number of rows. I perform other SQL tasks to eliminate the duplicate rows later. Can anyone please clarify the ALTER TABLE statement to basically turn off constraints? Thank you.