The default_values will not help you if he is not the case, especially if the column does not have a default specified.Since your column IS an identity column, you were having to say SET IDENTITY_INSERT ON before your script, and SET IDENTITY_INSERT OFF after you were done.