/
Performing SQL Maintenance
Performing SQL Maintenance
- Documentation Reviewer
Owned by Documentation Reviewer
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 checkboxes. The Grant Access checkbox will be marked automatically when dropping and creating tables and auto procedures.
- Choose Process.