Reply to Message

For existing invalid data
If you want to ignore the existing data when applying a check constraint, use the NOCHECK option. See the books online for more information.
22nd Mar 2007