Monthly Archives: September 2015

Reset Dynamics GP System Password

    1.  In SQL Management Studio, run this script to remove the existing password. UPDATE DYNAMICS.SY02400 SET PASSWORD = 0x0202020202020202020202020202020 2.  In GP, reset the system password.

Posted in Uncategorized | Leave a comment

Dynamics GP 2015 Important Notes

  Latest Service Pack At this writing it is very important when upgrading to Dynamics GP 2015 that you are on the current service pack/hotfix release. There are known issues that were resolved. Prior Version data in Tables Use the … Continue reading

Posted in Uncategorized | Leave a comment

Script to Obtain a List of Dynamics Company IDs

  select CMPANYID,CMPNYNAM,INTERID from Dynamics..SY01500

Posted in Uncategorized | Leave a comment

Script to List the Compatibility Levels of Databases

    select name, compatibility_level , version_name = CASE compatibility_level    WHEN 65  THEN ‘SQL Server 6.5’    WHEN 70  THEN ‘SQL Server 7.0’    WHEN 80  THEN ‘SQL Server 2000’    WHEN 90  THEN ‘SQL Server 2005’    WHEN 100 THEN ‘SQL Server 2008/R2’    … Continue reading

Posted in Uncategorized | Leave a comment

Enable CLR on SQL Server

  To enable CLR on SQL Server run this script:   sp_configure ‘clr enabled’, 1GORECONFIGUREGO

Posted in Uncategorized | Leave a comment

Dynamics GP Get List of DB Names and Companies

    SELECT  INTERID ‘Database’, CMPNYNAM ‘Company_Name’ FROM DYNAMICS..SY01500

Posted in Uncategorized | Leave a comment

Clicking “Add” in Part Master No Update

  If you find that you click any item in MAX and you get no response as in adding a part or if you try to update a part and receive an DB Error 4. This could be cause by … Continue reading

Posted in Uncategorized | Leave a comment

List the Recovery Model of All DB on SQL Server

/* Code to List all Recovery Models */ select [name], DATABASEPROPERTYEX([name],’recovery’)from sysdatabaseswhere name not in (‘master’,’model’,’tempdb’,’msdb’)

Posted in Uncategorized | Leave a comment

Errors on New Install of MAX things to check

1) Make sure that you have your anti-virus turned off. 2) Check your User Account control settings and make sure they are off 3) Make sure that .Net 3.51 is installed. 4) A new fresh install can also solve any … Continue reading

Posted in Uncategorized | Leave a comment

Quick SQL Server Version List

    http://sqlserverbuilds.blogspot.com/

Posted in Uncategorized | Leave a comment