tigertoolbox icon indicating copy to clipboard operation
tigertoolbox copied to clipboard

usp_AdaptiveIndexDefrag Fixes issue #244 object names using square brackets

Open AndrewG2 opened this issue 4 years ago • 1 comments

Removed problematic references using square brackets in dynamic SQL commands. This was also causing object names in log tables to also include the square bracket causing non-indexed statistics to fail during statistics update command, since the bracket was considered part of the stats name. Add comment proc @ver number comment inline in usp_AdaptiveIndexDefrag proc to allow users to see what version is deployed on a server. I've tested this on non-standard object names to verify.

AndrewG2 avatar Sep 28 '21 12:09 AndrewG2

CLA assistant check
All CLA requirements met.

ghost avatar Sep 28 '21 12:09 ghost