Dynamics 365 Great Plains
SQL View to Report on Fixed Allocation Accounts – azurecurve
If you are using Fixed Allocation Accounts in Microsoft Dynamics GP, there is only a standard report which shows the distribution accounts against one…
Tag: SQL
Dynamics 365 Great Plains
What’s included in those SQL rpt roles? – JenKuntz.ca
Today’s #TipTuesday is a security tip to help you identify what exact permissions the SQL fixed database roles have, that start with rpt*. If…
Dynamics 365 Great Plains
Formatting SQL – azurecurve
I create a fair amount of t_SQL in the form of selects, views and stored procedures. WHile I try to format my code to…
Dynamics 365 Great Plains
Assign SQL Login Security – azurecurve
This post is part of the series on Implementing SmartConnect, an integration tool from eOne Solutions, which can take data from any source and…
Dynamics 365 Business Central
Moving an on-premise Dynamics 365 Business Central database to Azure SQL via Powershell – Stefano Demiliani
If I have an on-premise installation of Dynamics 365 Business Central, can I move my database from a local SQL Server to Azure SQL…