How to Remove Notes Module in Sage 300

Resolution

  1. Log into SQL Server
  2. Use the following Query:
    • USE XXX (XXX = Company Database)
    • select * from CSAPP where SELECTOR = ‘KN’
    • delete from CSAPP where SELECTOR = ‘KN’
    • select * from DATADICT where TABLENAME like ‘KN%’
    • delete from DATADICT where TABLENAME like ‘KN%’
    • drop table KNNOTEH
    • drop table KNNTBLOB
    • drop table KNNTDIS
    • drop table KNSEQ