I am trying to manually add a row of data to a table within SQL Server 2005. The first column, called "MyData_Notes_ID" has the "Is Identity" set to "Yes" (it's also the Primary Key for the table), therefore, I don't include that column in my "INSERT" statement. However, when I execute the statement, it tells me that the "MyData_Notes_ID" field can't be null. What am I doing wrong?

Thanks,