I'm trying to help someone set up a test instance of Rock but they ran into an issue and their trying to solve it got over my head. I wanted to see if anyone else could shed some light on this. 


Here's the info I have received: 

Message 1:

Spent a lot of time today installing Rock on my Windows 10 PC, SQLServer 2019 Express. 

Got about 95% through the database installation with Install.aspx on my local website.

The Rock database installation Encountered the error in a stored procedure:

That Wasn't Suppose To Happen An error occurred creating database. Message: Incorrect syntax near 'INDEX'.

 

It’s hung near the INDEX statement in:

 

                    DECLARE @TempExitGiftCountDuration TABLE (

                          GivingId NVARCHAR(50) INDEX IX2 CLUSTERED

                          , DistinctCount INT

                    )



Message 2:

The installation completed the Database install past the 90% mark when it died on the INDEX error.


The Error occurs in

CREATE PROCEDURE [dbo].[spCrm_FamilyAnalyticsEraDataset]


The Error report provides this stored procedure. When I remove the INDEX definitions the stored procedure, it installs without errors.  However, I do not have access to the code in the installation script and the installation will not proceed when it sees the stored procedure is already installed.