Sage 100

 View Only
  • 1.  Deleted Companies are not Removed from the SQL Database

    Posted 05-01-2020 11:02
    v2019 Premium - Library Master, Main, Company Maintenance, Delete.  When a company is deleted using Company Maintenance, should the SQL tables also get deleted?   The customer deleted several old backup and test company codes but the databases still exist with tables that contain data.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------


  • 2.  RE: Deleted Companies are not Removed from the SQL Database

    Posted 05-01-2020 11:09
    Are they Sage tables, or objects added manually (or by enhancements)?

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Deleted Companies are not Removed from the SQL Database

    Posted 05-01-2020 11:10
    They are all the standard Sage 100 tables.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 4.  RE: Deleted Companies are not Removed from the SQL Database

    Posted 05-01-2020 11:12
    I can't say I remember seeing that before, but I don't often delete company codes.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 5.  RE: Deleted Companies are not Removed from the SQL Database

    Posted 05-01-2020 11:39
    Are there still references to them in MAS_System.SY_Company?

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------



  • 6.  RE: Deleted Companies are not Removed from the SQL Database

    Posted 05-01-2020 15:39
    @Phil McIntosh  There are no records in MAS_System.SY_Company for the deleted companies.  Could it SQL permissions related?  ie TRUCATE or DELETE permissions needed?


    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 7.  RE: Deleted Companies are not Removed from the SQL Database

    Posted 05-01-2020 15:40
    or DROP?

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 8.  RE: Deleted Companies are not Removed from the SQL Database

    Posted 05-01-2020 15:51
    MAS_User should be the database owner for all MAS_* databases.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 9.  RE: Deleted Companies are not Removed from the SQL Database

    Posted 05-01-2020 16:34
    Yes this sounds to me like someone messed with the MAS_User privileges

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------