Error Index Compression

[pvcardoso]

Hi!

Some issue running on SQL Server, follow inormation: Executing AdaptiveIndexDefrag v1.6.7 on Microsoft SQL Server 2005 - 9.00.5324.00 (X64) Aug 24 2012 18:28:47 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

Tryed Debug mode and found those two messages: Message 1: ALTER INDEX [ix_xxxxxxxxxxxxxxxxxx] ON [xxxxxxxxxxxxxxxxxx].[dbo].[xxxxxxxxx] REBUILD WITH (DATA_COMPRESSION = , FILLFACTOR = 90, SORT_IN_TEMPDB = OFF); Error 102 has occurred executing this command. Message: Incorrect syntax near ','. (Line Number: 1)

Message 2: Error 911 has occurred while determining row modification counter. Message: Could not locate entry in sysdatabases for database '[xxxxxxxxxxxxxx]'. No entry found with that name. Make sure that the name is entered correctly. (Line Number: 1)

For workaround on Message 1, I replaced line number 1941 / SET @rebuildcommand = @rebuildcommand + N'DATA_COMPRESSION = ' + @currCompression + ', ') with: SET @rebuildcommand = @rebuildcommand