Posted by: IS | February 20, 2009

How to remove the CEIP task on a new installation – from techknowledge


Run the following in query analyser o remove the customer experience improvement task.

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


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: