web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / SQL Triggers / Write a...
Customer experience | Sales, Customer Insights,...
Answered

SQL Triggers / Write access to database ?

(0) ShareShare
ReportReport
Posted on by Nikos06 5

Hi, I have an online dynamics crm application (xxxx.crm4.dynamics.com) and I'd like to monitor changes (insert, update and delete) on some entities and record those changes into a custom table.

With an SQL trigger it would be very easy to do so but I'm afraid the feature is not supported.

I can connect to the DB using sqlcmd or SSMS but the database is read-only.
Is there a way to gain write access to the database ?
Is it possible to create SQL triggers on the database ?
If not, are a plugin or an action from workflow the only ways to create SQL like triggers ? 

Best regards,
Nicolas.

I have the same question (0)
  • Verified answer
    Wahaj Rashid Profile Picture
    Wahaj Rashid 11,323 on at

    Hi,

    Thank you for your query.

    Write access on Database is not supported for online version. Even for on-premise it is not recommended.

    To track changes, you can enable Auditing, which will record any changes made to the records (CRUD) for the configured entities and fields.

    Audit data and user activity for security and compliance - Power Platform | Microsoft Docs

    Please note, there following levels of Auditing:

    • Global Auditing Settings: Go to Advanced Settings -> Auditing -> Global Audit Settings.
    • Entity Level: you can turn on or off Auditing for an entity.
    • Field Level: when auditing is enabled for an entity, you can choose fields to be audited.

    Here is an article on how to enable auditing:

    Enabling Auditing of Dynamics 365 Entities (coveo.com)

    Once, Auditing is enabled, you can see the Auditing Log in:

    • Audit Summary View: Go to Advanced Settings -> Auditing -> Audit Summary View.
    • Entity: open a record to see its Audit Log (Related -> Audit History).

    You can extract Audit Data using:

    Audit History Extractor  · XrmToolBox

  • Nikos06 Profile Picture
    Nikos06 5 on at

    Thank you very much Wahaj !

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 180 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 123

#3
CU11031447-0 Profile Picture

CU11031447-0 100

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans