SELECT  *FROM    sys.configurationsORDER BY name ;GO

  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…

    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.

  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

  select CMPANYID,CMPNYNAM,INTERID from Dynamics..SY01500

    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’ENDfrom sys.databases

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

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

  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 SQL Server CLR not being enabled. Check your SQL Server or ask your DB admin…

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