I installed the module on a clean DNN 4.8.2. portal.

Error:

Info	Executing 03.03.08.SqlDataProvider
StartJob	Start Sql execution: 03.03.08.SqlDataProvider file
EndJob	End Sql execution: 03.03.08.SqlDataProvider file
Info	Executing 04.00.00.SqlDataProvider
StartJob	Start Sql execution: 04.00.00.SqlDataProvider file
Failure	SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: For DROP INDEX, you must give both the table and the index name, in the form tablename.indexname. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /*** Change index to be on EventDateBegin instead of EventDateEnd ***/ if exists (select * from dbo.sysindexes where id = object_id(N'dbo.[Events]') AND name = N'IX_Events_1') drop index [IX_Events_1] on dbo.[Events] with ( online = off ) System.Data.SqlClient.SqlException: There is already an index on table 'Events' named 'IX_Events_1'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE INDEX [IX_Events_1] ON dbo.[Events]([EventDateBegin]) ON [PRIMARY]
EndJob	End Sql execution: 04.00.00.SqlDataProvider file
EndJob	Finished Sql execution

Cheers,

Jos

I tested the script below and it worked.

if exists (select * from dbo.sysindexes where id = object_id(N'{databaseOwner}[{objectQualifier}Events]') AND name = N'IX_{objectQualifier}Events_1')
drop index {databaseOwner}[{objectQualifier}Events].[IX_{objectQualifier}Events_1]

GO

CREATE  INDEX [IX_{objectQualifier}Events_1] ON {databaseOwner}[{objectQualifier}Events]([EventDateBegin]) ON [PRIMARY]

The problem might be the attribute: with ( online = off )

I think this is only supported (documented) for Enterprise versions of SQL2005. I tested this before on standard version of SQL2005, and that version did not complain. I have not tested this on SQLexpress or SQL2000.