How To Remove The CEIP Reminder

When you install Microsoft Dynamics GP it automatically creates a recurring reminder for the Microsoft Customer Experience Improvement Program. In most cases this reminder is not wanted but removing it through the system for every user can be a bit time consuming;

For each user, log into Microsoft Dynamics GP and open the Reminders window (Microsoft Dynamics GP menu » Reminders) and open the CEIP task. In the window click Name and select an option. Flag the task as Completed and move onto the next user and repeat.

However, help is at hand in with two short SQL scripts.

As always, before running the scripts ensure you have a valid backup of your system and company databases.

The first script removes the reminder from all users;
DELETE FROM
   DYNAMICS..SY01403
WHERE
   LinkTo = 2
   AND CmdID = 269
   AND CmdFormID = 1568
   AND CmdDictID = 0

The second script flags all users as not participating in CEIP;
USE DYNAMICS
SET NOCOUNT ON
DECLARE @Userid CHAR(15)
DECLARE cCEIP CURSOR FOR
      SELECT A.USERID
      FROM SY01400 A LEFT JOIN SY01402 B ON A.USERID = B.USERID AND B.syDefaultType = 48
      WHERE B.USERID IS NULL OR B.SYUSERDFSTR NOT LIKE '1:%'
OPEN cCEIP
WHILE 1 = 1
BEGIN
   FETCH NEXT FROM cCEIP INTO @Userid
   IF @@FETCH_STATUS <> 0 BEGIN
      CLOSE cCEIP
      DEALLOCATE cCEIP
      BREAK
   END

   IF EXISTS (SELECT syDefaultType FROM DYNAMICS.dbo.SY01402 WHERE USERID = @Userid AND syDefaultType = 48)
   BEGIN
      PRINT 'adjusting ' + @Userid
      UPDATE DYNAMICS.dbo.SY01402
      SET SYUSERDFSTR = '1:'
      WHERE USERID = @Userid AND syDefaultType = 48
   END
   ELSE BEGIN
      PRINT 'adding ' + @Userid
      INSERT DYNAMICS.dbo.SY01402 ( USERID, syDefaultType, SYUSERDFSTR )
      VALUES ( @Userid, 48 , '1:' )
   END
END /* WHILE */
SET NOCOUNT OFF