tengo esta mesa sql

CREATE TABLE Notes(
    NoteID [int] IDENTITY(1,1) NOT NULL,
    NoteTitle [nvarchar](255) NULL,
    NoteDescription [nvarchar](4000) NULL
) CONSTRAINT [PK_Notes] PRIMARY KEY CLUSTERED 
(
    NoteID ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF,
 ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

Y quiero copiar registros de una tabla temporal INCLUYENDO el NoteID (usando la consulta SQL) ..

este es mi guión

SET IDENTITY_INSERT Notes OFF

INSERT INTO Notes (NoteID, NoteTitle,NoteDescription)
SELECT NoteID, NoteTitle,NoteDescription from Notes_Temp

SET IDENTITY_INSERT Notes ON

Con este script, obtengo un error:

Cannot insert explicit value for identity column in table 'Notes' when IDENTITY_INSERT is set to OFF.

¿hay otra forma de insertar registros en una tabla con una columna de identidad usando la consulta SQL?