/* 
     Enable Technical Account for InHouse Investigations

       Sign in as NexxsysSup, then run.

       Should be run on any DB pulled for investigational purposes
*/

CALL p_EnableTechnical();
UPDATE INTERFACE SET ActiveInd = 0 WHERE Code = 'NXUPDATER' AND SubCode = 'UPDATER';
UPDATE INTERFACE SET ActiveInd = 0 WHERE Code = 'NXUPDATER' AND SubCode = 'LAUNCHER';
UPDATE INTERFACE SET ActiveInd = 0 WHERE Code = 'NUMARA' AND SubCode = 'LAUNCHER';
UPDATE accountingsysteminterface SET activeind = 0;
UPDATE accountingsysteminterface SET host = 'http://COMPUTERNAME/BVWebService' where asicode = 'BV';
UPDATE accountingsysteminterface SET host = 'POS_SYSTEM' where asicode = 'POS';
UPDATE Preference SET SValue = 0 WHERE Code = 'DIT';
CALL p_EnableTechnical();
commit;