更新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

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch

Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore

Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade

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