I have a custom module that I built and have Redgates SQL Compare.  I have made many changes to my module - and created the sql to use for my SqlDataProvider sql.

Everything else works great - but when installing the upgrade - When it starts to execute my SQL file it chokes and says there's "Incorrect Syntax Near 1"

Here's the original line in my .SqlDataProvider file on upload:
set @startRowIndex = @maximumRows * @startRowIndex + 1

Here's what it's been stripped to:
set @startRowIndex = @maximumRows * @startRowIndex 1

My plus sign has been removed.... What gives?  I currenlty have to run the SQL script either through the DNN SQL or using SSMS ---

What am I doing that's so "wrong"?

Interesting thing to try!  But that still didn't fix it.  I don't know why.