Cannot insert the value NULL into column...

I get the error "Cannot insert the value NULL into column RecordingId..."
My understanding is that this value should be generated automatically as long as I do not refer to it in my SQL statement. But I still get the error.  RecordingId is obviously the unique ID of the table in question.  Below is the statement that I am using.
INSERT INTO Recording                       (ScheduleName, ScheduleId, KeepUntilMode, KeepUntilValue, RecordingFileName, IsPartialRecording, Title, SubTitle) SELECT     ScheduleName, ScheduleId, KeepUntilMode, KeepUntilValue, RecordingFileName, IsPartialRecording, Title, SubTitle FROM         Recording AS Recording_1 WHERE     (ScheduleName = 'house')
...