SQL Server – Page 2 – Winthrop Development Consultants Blog

Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#GPPT Beginner’s Guide to Adding Custom Fields – Update: Using manual SQL tables

Oct 6, 2025 Tagged with Development, Dexterity, GP Power Tools, GPPT, SQL No Comments

Welcome to the tenth article as an update to the series of articles that explains in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.

The series should be read in order starting with the introduction article:

#GPPT Beginner’s Guide to Adding Custom Fields – Introduction

In this article we will show how to use manual SQL tables to store data rather than the DUOS table. In the previous article we included the Customization Maintenance packages. In the following article we will show how to use GPPT Custom Tables (even better than manual SQL tables).

Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#GPPT Beginner’s Guide to Adding Custom Fields – Update: Including the Modified Resources

Oct 3, 2025 Tagged with Development, Dexterity, GP Power Tools, GPPT, SQL No Comments

Welcome to the ninth article as an update to the series of articles that explains in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.

The series should be read in order starting with the introduction article:

#GPPT Beginner’s Guide to Adding Custom Fields – Introduction

In this article we will provide updates to the project adding the modified window and report to the project. In the following articles we will show how to use manual SQL tables and then GPPT Custom Tables (even better than manual SQL tables).

Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#GPPT Tracking changes to Item Cards Version 5

Aug 13, 2025 Tagged with Application, Development, Dexterity, GP Power Tools, GPPT, SQL No Comments

This is yet another update to the previous version of the change tracking project for Item cards:

#GPPT Tracking changes to Item Cards Version 4

Based on the version 4 project, this update for GP Power Tools Build 32 or later adds support for the Accounts window. Note it does require Build 32 or later to work.

Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#GPPT Tracking changes to Customer and Vendor Cards Version 6

Aug 11, 2025 Tagged with Application, Development, Dexterity, GP Power Tools, GPPT, SQL No Comments

This is yet another update to the previous versions of the change tracking projects for Customer and Vendor cards:

#GPPT Tracking changes to Customer and Vendor Cards Version 5

Based on the version 5 projects, this update for GP Power Tools Build 32 or later adds support for the Accounts window. Note it does require Build 32 or later to work.

Development, Dynamics, GP, Microsoft, SQL Server

#MSDynGP Checking which Products have been used in Dynamics GP

Jul 30, 2025 Tagged with Application, SQL 1 Comment

This article is designed to help you perform a system audit on your Microsoft Dynamics GP system and is used as part of my Microsoft Dynamics GP Systems Audit session in the first week of the Dynamics GP Strategic Planning Digital Summit being held each Wednesday for the next 5 weeks.

Identifying the installed products in the system is fairly easy as you can look at the Dynamics.set launch file to see all the Dexterity product dictionaries loaded.

However, having a product loaded in a system does not necessarily mean that it has been used.

Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#GPPT Tracking changes to Item Cards Version 4

Jul 16, 2025 Tagged with Application, Development, Dexterity, GP Power Tools, GPPT, SQL No Comments

This is another update to the previous version of the change tracking project for Item cards:

#GPPT Tracking changes to Item Cards Version 3

Based on the version 3 project, this update for GP Power Tools Build 32 changes the project to use a Custom Table and Custom Table Buffer calls rather than SQL Scripts and Parameter Lists. So, it does require Build 32 or later to work.

Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#GPPT Tracking changes to Customer and Vendor Cards Version 5

Jul 15, 2025 Tagged with Application, Development, Dexterity, GP Power Tools, GPPT, SQL No Comments

This is another update to the previous versions of the change tracking projects for Customer and Vendor cards:

#GPPT Tracking changes to Customer and Vendor Cards Version 4

Based on the version 4 projects, this update for GP Power Tools Build 32 changes the project to use a Custom Table and Custom Table Buffer calls rather than SQL Scripts and Parameter Lists. So, it does require Build 32 or later to work.

Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#GPPT SQL Server Version Requirement Warning

Dec 17, 2024 Tagged with Application, GP Power Tools, GPPT, SQL No Comments

GP Power Tools build 30.2 added a feature to check the installed SQL Server version against the minimum supported version, as per the published System Requirements for Microsoft Dynamics GP, and will warn on login if the version of SQL Server does not meet the minimum system requirements.

Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#GPPT Preventing Invalid Characters in Customer, Vendor and Item IDs

Apr 29, 2024 Tagged with Application, Development, Dexterity, GP Power Tools, GPPT, SQL 2 Comments

This is another “Must Have” free customization example for you Microsoft Dynamics GP system when you have GP Power Tools – Developer Tools module.

When creating new Customer, Vendor and Item cards, it is possible to include certain characters in the ID fields which can cause issues with Microsoft Dynamics GP, its ISV products and integrating products.

Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#GPPT You do not have permission to run FN_TRACE_GETINFO

Feb 5, 2024 Tagged with Application, GP Power Tools, GPPT, SQL No Comments

GP Power Tools has the ability to capture SQL Profile Traces as one of the five different types of logs it can generate from Microsoft Dynamics GP.

To achieve this, GP Power Tools needs to change some permissions on the SQL Server so that it can both generate the Trace programmatically and also copy the resulting files to the shared Logging Folder.