One problem I found with this example... if you add a note with an attachment it works fine. If you add a note without an attachment it won't accept a null in the Attachment column and throws up an error.
Maybe this is just a sql2005 thing? Not sure how to get around this as the Attachment column is set to accept nulls.