Views:

Applies to Product - Dynamics 365 Supply Chain Management


What’s happening?
Requesting the execution of a SQL query, specifically a Drop Table statement, against a production environment to facilitate the deployment of updates.
 

Reason:
The need to drop a custom table in the production database to proceed with the deployment of updates requested by the customer.
 

Resolution:

  1. Confirm that the SQL script to drop the table has been secured and approved by the relevant stakeholders.
  2. Ensure that the execution of the SQL script is necessary and that no alternative solutions (such as UI fixes or other methods) can resolve the issue.
  3. Execute the provided SQL script against the production database.
  4. After execution, verify that the table has been successfully dropped by attempting to access it, which should result in a navigation error if the drop was successful.
  5. If any issues arise during the deployment or if further assistance is needed, log a new support ticket to engage additional support resources.