update CRM7.CONFIG set
  text_path = 'F:\SuperOffice\Customer Service\text',
  attachment_path = 'F:\SuperOffice\Customer Service\attachments',
  template_path = 'F:\SuperOffice\Customer Service\templates',
  cgi_url = 'http://meteringservices.kbg1.net.fmcti.com',
  warning = 'F:\SuperOffice\Customer Service\log\warning',
  cgi_url_internal = 'http://meteringservices.kbg1.net.fmcti.com'

update crm7.attachment_location set path = 'F:\SuperOffice\Customer Service\attachments'

update CRM7.REGISTRY set value = 'F:\SuperOffice\Customer Service\bin\ejSender.exe' where reg_id = 1
update CRM7.REGISTRY set value = 'F:\SuperOffice\Customer Service\bin\ejOutbox.exe' where reg_id = 22
update CRM7.REGISTRY set value = 'F:\SuperOffice\Customer Service\bin\dbi.exe' where reg_id = 131
update CRM7.REGISTRY set value = 'F:\SuperOffice\Customer Service\bin\NetServerGetTicket.exe' where reg_id = 245
update CRM7.REGISTRY set value = 'F:\SuperOffice\Customer Service\log\' where reg_id = 40
update CRM7.REGISTRY set value = 'F:\SuperOffice\Customer Service\bin\ejImageResizer.exe' where reg_id = 284

-- Fix changed URL for inline images in Ejournal/Customer Service
UPDATE crm7.ej_message set html_body = cast(replace(cast(html_body as nvarchar(max)), 'ejournal.abax.local', 'service.abax.no') as ntext)
WHERE html_body like '%ejournal.abax.local%'

UPDATE crm7.ej_message set body = cast(replace(cast(body as nvarchar(max)), 'ejournal.abax.local', 'service.abax.no') as ntext)
WHERE body like '%ejournal.abax.local%'

UPDATE crm7.kb_entry set question = cast(replace(cast(question as nvarchar(max)), 'ejournal.abax.local', 'service.abax.no') as ntext)
WHERE question like '%ejournal.abax.local%'

UPDATE crm7.kb_entry set answer = cast(replace(cast(answer as nvarchar(max)), 'ejournal.abax.local', 'service.abax.no') as ntext)
WHERE answer like '%ejournal.abax.local%'

UPDATE crm7.REPLY_TEMPLATE_BODY
set body_html = cast(replace(cast(body_html as nvarchar(max)), 'ej.epocket.no', 'cs.guardsystems.com') as ntext)
WHERE body_html like '%ej.epocket.no%'


UPDATE crm7.s_message
set html_message = cast(replace(cast(html_message  as nvarchar(max)), 'ej.epocket.no', 'cs.guardsystems.com') as ntext)
WHERE html_message like '%ej.epocket.no%'