This routine can be used to drop and create tables and auto procedures, grant access, and clear data from tables. You must be logged in as “sa”.
- Choose Microsoft Dynamics GP > Tools > Utilities > Equipment > SQL Maintenance.
- Choose the System or Company radio button in the Table Series field.
- Choose a Database from the drop-down list.
- Choose the tables you wish to maintain.
- Choose to drop and create tables and auto procedures or clear data by marking the check boxes. The Grant Access check box will be marked automatically when dropping and creating tables and auto procedures.
- Choose Process.