tigertoolbox
tigertoolbox copied to clipboard
usp_AdaptiveIndexDefrag Fixes issue #244 object names using square brackets
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.