I've found that if your source query includes the column that contains nulls and nulls are encountered, the SQL default constraint will not fire.  If you leave the column out...

Is the server a multiprocessor box?  One of my colleagues experienced an issue with the max degree of parallelism setting on a multiprocessor server in which the parallel query plan...