Installation with MSSQL

[mfnvidia]

I am trying to install the latest nightly build: mantisbt-1.3.0dev-2010-06-02-master-f653c1f

I have my configuration setup to use MSSQL through a DSN, and MOST of the install script works, but then it gets an error:

ALTER TABLE mantis_user_pref_table ALTER COLUMN redirect_delay INT DEFAULT 0 NOT NULL
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword 'DEFAULT'.

If I run this query in SQL Studio, i get the same error. I am not even sure why it's doing this change... it appears to be a field used as a binary that is intially created as a BIT instead of an INT. Why do we need to change it?

If I remove the "DEFAULT 0" I no longer get a syntax error, but I do get another error:

The object 'DF__mantis_us__redir__0623C4D8' is dependent on column 'redirect_delay'.

Why isn't the table created with the right schema in the first place? Why alter the columns afterwards? Why doesn't it wait until after it's done creating tables and manipulating them before it creates indexes or does other stuff?

Has anybody gotten this working with MSSQL? I've tried earlier builds but they had MORE problems.