Dynamics 365 Great Plains
SQL Script to find SQL Objects containing specific text
I did some work for a client recently which involved some custom SQL objects created by a consultant at their previous VAR. It appeared…
Tag: SQL
Dynamics 365 Great Plains
SQL Stored Procedure to delete old Microsoft Dynamics GP Document Attachments
The Document Attachment feature was introduced in Microsoft Dynamics GP 2013 RTM and has been enhanced a number of times since. One of the…
Dynamics 365 Great Plains
SQL View to return Microsoft Dynamics GP Workflow step approvers
I was recently talking to a client who was looking at creating a SQL script which they could run for the auditors which shows…
Dynamics 365 Business Central
Configure MAXDOP (max degree of parallelism) on SQL Server 2016… 2019)
The Microsoft SQL Server max degree of parallelism (MAXDOP) configuration option controls the number of processors that are used for the execution of a query in…
Dynamics 365 Great Plains
Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements: Compatibility with SQL Server 2019, Windows Server 2019, and Office 2019
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements series where I am…