Review SQL Server Instance Configuration

SELECT  *
FROM    sys.configurations
ORDER BY name ;
GO

How to Clear Disconnected Users from Dynamics GP

 

delete from DYNAMICS..ACTIVITY

    where USERID not in

        (select loginame from master..sysprocesses) 

delete from tempdb..DEX_SESSION 

    where session_id not in 

        (select SQLSESID from DYNAMICS..ACTIVITY) 

delete from tempdb..DEX_LOCK 

    where session_id not in 

        (select SQLSESID from DYNAMICS..ACTIVITY) 

delete from DYNAMICS..SY00800 

    where USERID not in 

        (select USERID from DYNAMICS..ACTIVITY) 

delete from DYNAMICS..SY00801 

    where USERID not in 

        (select USERID from DYNAMICS..ACTIVITY)

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.

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 reference below to untangle the problems of prior versions in the tables

https://community.dynamics.com/gp/f/32/t/134557

Script to Obtain a List of Dynamics Company IDs

 

select CMPANYID,CMPNYNAM,INTERID from Dynamics..SY01500

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'
    WHEN 110 THEN 'SQL Server 2012'
    WHEN 120 THEN 'SQL Server 2014'
END
from sys.databases

Enable CLR on SQL Server

 

To enable CLR on SQL Server run this script:

 

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO