Agreed. We will amend our docs.

Actually you are the first to point this out - we just have very fast support!

Gemini 3.6 will support SQL Server 2000 using the fix provided:


In the upgrade script do not run the section:

/******************
Modifing old SQL types - Do not run for SQL 2000 or 7
*******************/
ALTER TABLE geminiissues ALTER COLUMN longdesc NVARCHAR(MAX)
ALTER TABLE geminiissuecomments ALTER COLUMN comment NVARCHAR(MAX) NOT NULL
ALTER TABLE geminiprojectversionattributevalues DROP CONSTRAINT geminiprojectversionattributesvaluesattributvaluedef
ALTER TABLE geminiprojectversionattributevalues ALTER COLUMN attributevalue NVARCHAR(MAX) NOT NULL
ALTER TABLE geminiprojectversionattributevalues ADD CONSTRAINT geminiprojectversionattributesvaluesattributvaluedef DEFAULT(N'') FOR attributevalue
ALTER TABLE geminiissueattachments ALTER COLUMN filecontent VARBINARY(MAX)
ALTER TABLE geminiissuealerts ALTER COLUMN alertdata VARBINARY(MAX)
ALTER TABLE geminiprojectrepository ALTER COLUMN nodedata VARBINARY(MAX)
GO

update (n)varchar(max) to (n)text and from varbinary(max) to image.

And update the createprocs.sql script:

CREATE PROCEDURE geminilogmessage
                @messagetype varchar(30),
                @messagesource varchar(30),
                @logmessage varchar(MAX),

to

CREATE PROCEDURE gemini_logmessage
                @messagetype varchar(30),
                @messagesource varchar(30),
                @logmessage varchar(7999),