You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
What is the current behavior?
If i start the sript i get some errors like "Incorrect syntax near '-'."
so i changed
Line 364+623: set @sqlcommand = 'alter index ' + @indexName + ' on ' + @currentTableName + ' Reorganize';
To: set @sqlcommand = 'alter index [' + @indexName + '] on ' + @currentTableName + ' Reorganize';
If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem via http://sqlfiddle.com/
The IndexName is e.g. "ClusteredColumnStoreIndex-20190410-152738"
Which versions of SQL Server and which OS are affected by this issue? Did this work in previous versions of our procedures?
SQL Server 2016 SP2 CU10
The text was updated successfully, but these errors were encountered:
There is a bug in doMaintenance
What is the current behavior?
If i start the sript i get some errors like "Incorrect syntax near '-'."
so i changed
Line 364+623: set @sqlcommand = 'alter index ' + @indexName + ' on ' + @currentTableName + ' Reorganize';
To: set @sqlcommand = 'alter index [' + @indexName + '] on ' + @currentTableName + ' Reorganize';
If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem via http://sqlfiddle.com/
The IndexName is e.g. "ClusteredColumnStoreIndex-20190410-152738"
Which versions of SQL Server and which OS are affected by this issue? Did this work in previous versions of our procedures?
SQL Server 2016 SP2 CU10
The text was updated successfully, but these errors were encountered: