1

External Events Database Triggers

Feedback / Issues and Bug Report / Bugs or Issues

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?

4 replies

null
    • smason
    • 1 yr agoTue, April 18, 2023 at 12:09 PM UTC
    • 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
    • 1 yr agoWed, April 19, 2023 at 2:48 PM UTC
    • Reported - view

    Ferdinand Tonby-Strandborg

    We added a work item to support this functionality in a later release!

      • ferdinand_TS
      • 1 yr agoWed, April 19, 2023 at 5:57 PM UTC
      • Reported - view

      Hi Steve Mason,

      That's great to hear! Thank you! 🙂

    • smason
    • 1 yr agoTue, September 12, 2023 at 11:59 AM UTC
    • 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.

Login to reply

Content aside

print this pagePrint this page
  • Status Fixed
  • 1 Likes
  • 1 yr agoTue, September 12, 2023 at 11:59 AM UTCLast active
  • 4Replies
  • 89Views
  • 3 Following