Return
-
Title
Error during execution or optimization of queries using synonyms: "Invalid SQL statement." -
Description
The following error occurs during execution or optimization of queries using synonyms:
"Invalid SQL statement.
Table does not exist.
Invalid object name ..Possible causes of this error are:
- You are not pointing to the user and the database where the objects
referenced by the SQL are located.
Therefore, the objects cannot be found.
- You are using T-SQL code or more than one SQL statement. Only a single
SELECT/INSERT/DELETE/UPDATE can be processed.
For multiple SQL statements or T-SQL code, first use the SQL Scanner
module to extract the SQL statements." -
Resolution
WORKAROUND:
NoneSTATUS:
Enhancement request ST74220 has been submitted to Development for consideration in a future release Quest SQL Optimizer for SQL Server. -
Defect ID
ST74220