Quest SQL Optimizer for SQL Server was used to generate an index recommendation (shown below). The index creation script it generated is below.
/* Recommended Index(es) :
CREATE NONCLUSTERED INDEX QUEST_SX_IDX_6019B7D145A56EED
ON [ TEST ].[ dbo ].[ Template ]
( [ CHAINID ] );
*/
Optimizer added spaces around the database, schema, object, and field. These added spaces aren't valid, executing the script gives this error:
Msg 1088, Level 16, State 12, Line 1 Cannot find the object " TEST . dbo . Template " because it does not exist or you do not have permissions."
Software error
WORKAROUND:
Edit the statement and remove the spaces
STATUS:
Waiting for fix in a future release of Quest SQL Optimizer for SQL Server.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center