更新In Memory table發生The feature ‘EVENT NOTIFICATION’ is not supported with memory optimized tables

Edward Kuo
Apr 21 · 2 min read
Image for post
Image for post

每次都會發生這問題,特別來記錄一下,以免下次找不到問題。EVENT NOTIFICATION本身是SQL Server屬於Server 層級的是件通知。就官方文件寫是

事件通知會傳送事件的詳細資訊給 Service Broker 服務。 事件通知會將這些事件的資訊傳送給 Transact-SQL 服務,以回應各種 Service Broker 資料定義語言 (DDL) 陳述式和 SQL 追蹤事件。

事件通知可用來執行下列工作:

記錄和檢閱發生在資料庫的變更或活動。

執行動作以非同步而不是同步的方式來回應事件。

事件通知可提供程式設計替代方案給 DDL 觸發程序和 SQL 追蹤。

主要在於讓DBA監控DB有發生甚麼異動,可以做追蹤與通知,基本上這運作沒太大問題,如果今天你要更新或是新增In Memory Table或是相關程序,就會出現下面錯誤訊息

The feature ‘EVENT NOTIFICATION’ is not supported with memory optimized tables

Image for post
Image for post

參考資料

EK.Technology Learn

Design,Thinking,Coding & have fun every thing

Medium is an open platform where 170 million readers come to find insightful and dynamic thinking. Here, expert and undiscovered voices alike dive into the heart of any topic and bring new ideas to the surface. Learn more

Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox. Explore

If you have a story to tell, knowledge to share, or a perspective to offer — welcome home. It’s easy and free to post your thinking on any topic. Write on Medium

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store