Article Details
Id: | 13698 |
Product: | finPOWER Connect |
Type: | NEW |
Version: | 3.00.00 |
Opened: | 18/03/2016 |
Closed: | 21/03/2016 |
Released: | 06/07/2016 |
Job: | J017090 |
Reset Database Permissions; fails with a "Incorrect syntax error near" error
The Reset Database Permissions function for Microsoft SQL Server, may fail with an "Incorrect syntax error near" error.
This was found to be an issue with a user added table that begun with a number, e.g. "7TABLE". This issue will not happen with a standard finPOWER Connect database.
Your Software Licence Agreement specifically DOES NOT allow the finPOWER Connect database schema and/ or data to be altered. However, with written permission, Intersoft Systems may allow additional tables and indexes on existing tables to be added. Any Tables or Indexes need to be carefully named to avoid future conflicts. Please talk to Intersoft Systems before considering altering your database as it can have far reaching consequences.