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