When trying to use AUTO OPTIMIZE on a SELECT, the following error is given:
"Error occured during browsing data from database.
The DBCC permission was denied on the object '1371151930', database "AH0PD01', schema 'dbo'. "
Optimizer needs these permissions to retrieve table statistic via the SQL Server DBCC command.
Please grant the schema these permissions. Below are the DBCC commands that QSOSS will execute and their required DB privileges.
Please check with the SQL Server DBA.
Waiting for fix in a future version of Quest SQL Optimizer for SQL Server.