Uncategorized

When upgrading MAX databases from SQL 2005 be sure to change the legacy setting of TORN_PAGE to CHECKSUM in the PAGE_VERIFY setting of your MAX database. 

  In some cases setting the database Parameterization setting may increase performance of MRP Explosion and other sizable batch processes. Testing this in your test environment is definitely recommended. Change this setting under options in your SQL database and benchmark the change in processing time.

I recently had to create a report that needed adjacent columns of serial numbers much like columns in a Word document. I pored over several advices but in the end discretely defining the number of serial numbers per column worked out best. I used the code below to get a row number and list them…

  SELECT Order_Master.ORDNUM_10, CM.NAME_23, CM.COMNT1_23, CM.COMNT2_23, CM.UDFREF_23FROM Order_Master INNER JOINSO_Master SMon LEFT(CUSORD_10,8) = SM.ORDNUM_27inner join Customer_Master CM on SM.CUSTID_27 = CM.CUSTID_23WHERE – Add anything here that you need to select the proper record set.

    @echo =========  SQL Server Ports  ===================@echo Enabling SQLServer default instance port 1433netsh firewall set portopening TCP 1433 “SQLServer” @echo Enabling Dedicated Admin Connection port 1434netsh firewall set portopening TCP 1434 “SQL Admin Connection” @echo Enabling conventional SQL Server Service Broker port 4022  netsh firewall set portopening TCP 4022 “SQL Service Broker” @echo Enabling…

If you are upgrading to Dynamics GP 2015 make sure that you are at least on SQL Server 2008 R2 and running Windows Server 2012.Vince Stefanetti

  Always use caution when editing live tables in MAX. On occasion a hard closure of MAX or a dropped connection can cause MAX to retain the user in the ERMUD table which is in the EXACTMAX master database. You can query the ERMUD table and review the details to see which users are stuck….

  If you need to use a Google Account for setting up email notifications on SQLServer make sure you use the 2 step security method. Login to the Google Account Go to Account Settings for the Account – Upper Right when you log in. Select Sign-in and Security   4. Then – 2 step 5….

  This defines how SQL Server will sort Case and Accents ( glyphs to determine pronunciation) and Kana (Japanese syllabic writing). Capitalization and the Diacritical ( Dia – through and krinein “to separate”) marks are included in sort considerations by SQL Server. Selecting the collation sequence on setup provide the Instance Collation however the collation…

When a double period is used, as in:   ExactMAXSampleDB..Part_Master   This means the schema is inferred to be the default schema of the current login.   In most cases this will be .dbo. So instead of having to provide it one could use the shortcut of the “..” or more correctly the default for…