AnsweredAssumed Answered

Schema update issues on SQL Server

Question asked by qasimh on Nov 26, 2007
Latest reply on Dec 5, 2007 by qasimh
I'm upgrading Alfresco 2.0 to 2.1, using Tomcat/MS SQL Server.  I see that some schema upgrade scripts are being generated.  I am trying to run these scripts on the db before starting the Alfresco server.

More specifically, I'm using SQL Server 2000.  I know the scripts generated are for SQL Server 2005, so there may be some issues.

The line that I'm having trouble with is similar to this:

CREATE INDEX FKFFF41F9960601995 ON alf_access_control_entry (permission_id);(optional)

The key word "(optional)" is not being recognized.

I understand this keyword, when used in SQL Server 2005, let's the script continue and complete when errors are detected.

What is the alternative syntax to use in SQL Server 2000?