Dynamics 365 Great Plains
SQL Scripts for Microsoft Dynamics GP: Series Index
Long time readers of this site will be aware that I changed jobs in September this year and no longer work with Microsoft Dynamics…
Tag: SQL
Dynamics 365 Great Plains
SQL Snippets: Select Primary Keys for All Tables in Database
This post is part of the series on SQL Snippets. The following SQL snippet will select all primary keys for all tables in the…
Dynamics 365 Great Plains
SQL Snippets: Select All Fields for All Tables In Database
This post is part of the series on SQL Snippets. The following SQL snippet will select all fields for all tables in the selected…
Dynamics 365 Great Plains
SQL Script to Alter Server, Instance and Database References in Views After Copying Microsoft Dynamics GP Databases To A New Server
Four years ago I wrote a script which changed server and database names embedded within SQL views after a live Microsoft Dynamics GP company…
Dynamics 365 Great Plains
SQL View to Return the Microsoft Dynamics GP Workflow Step Assignments
A common request from clients using Microsoft Dynamics GP workflow was a way to easily be able to review to whom workflow steps were…