• I recently read an article CHECK constraints in SQl Server http://codingsight.com/check-constraints-in-sql-server/ . may be it could be helpful for you too