How to remove the Customer Experience Improvement Program (CEIP) task from Microsoft Dynamics GP | Collection of Useful Microsoft Dynamics GP Sql Commands, Tips and Tricks

	GP-DYNAMICS
	Custom Programming

Collection of Useful Microsoft Dynamics GP Sql Scripts, Tips and Tricks

How to remove the Customer Experience Improvement Program (CEIP) task from Microsoft Dynamics GP

Long Description:
The CEIP task appears after you install Microsoft Dynamics GP. CEIP collects information about how a customer uses Microsoft products and about any problems that customers experience.
Source Knowledge Base

IMPORTANT:
Commands with UPDATE, DELETE or DROP can ruin your data! Please use these queries with caution. We highly recommend that you backup your database before trying out these commands and to load them up first on a test server. Use at your own risk.

Associated SQL Command:
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
Viewed: 14500 times

Submitted by: Venugopal G A

About Venugopal G A

View complete list

previous script

next script

Did you find this script useful?
Please reciprocate by submitting your own script
or any proven advice regarding Dynamics GP use. Click here.

Send the script above to a friend

Send to EMAIL: *
Short MESSAGE: *
Sender NAME: *
Sender EMAIL:
Validation code: *	Enter 123

Trademarks: Microsoft™, Microsoft Dynamics™ and/or Microsoft logos, products, and services referenced in this site are either trademarks or registered trademarks of Microsoft Corporation.

Disclaimer: This product is not officially endorsed by Microsoft. Furthermore, this website does not imply representation of Dynamics™ or relationship with Microsoft in any form.