title: The feature 'EVENT NOTIFICATION' is not supported with memory optimized tables
body: <p>I have been battling to create a table type in SQL Server 2016. There are other table types which already exists in the database, but I can't seem to create a new one anymore and I keep getting the error <strong>The feature 'EVENT NOTIFICATION' is not supported with memory optimized tables.</strong> I tried some googling and can't seem to find similar issue. I generated the DB scripts to test locally if on the newly created DB it will work and works just fine. What could I be missing?</p>
  <p>My script looks something like this:</p>
  <pre><code>USE MyDB
  GO
  
  CREATE TYPE [dbo].[MyTableType] AS TABLE(
      [Col1] int,
      [Col2] nvarchar(100),
       PRIMARY KEY NONCLUSTERED HASH 
  (
      [Col1]
  )WITH ( BUCKET_COUNT = 128)
  )
  WITH ( MEMORY_OPTIMIZED = ON )
  GO
  </code></pre>