External Events Database Triggers

Feedback / Issues and Bug Report / Bugs or Issues

ferdinand_TS
2 yrs ago
4replies
Fixed

Dear Canary team,

I have an external MSSQL server storing Events, and I would like triggers in the database on INSERTs and UPDATEs on the Events and EventProperties tables, however I cannot make this work.

Most solutions I have found online to the error suggest changing the INSERT statement, and so I was wondering if there is any way to do so? Or if there is an alternative solution to my issue?

- smason
- 2 yrs ago
- Reported - view
Hi Ferdinand Tonby-Strandborg ,

According to development, you cannot add an insert or update trigger to those tables with the syntax we are using. Sorry
- smason
- 2 yrs ago
- Reported - view
Ferdinand Tonby-Strandborg

We added a work item to support this functionality in a later release!
- ferdinand_TS
  
  2 yrs ago
  
  Reported - view
  Hi Steve Mason,
  
  That's great to hear! Thank you!
- smason
- 1 yr ago
- Reported - view
Hi Ferdinand Tonby-Strandborg ,

This has been resolved in v23.0. You can reach out to your Canary representative if you need a download link.