Schema update issues on SQL Server

[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?

Thanks,

-Q

[qasimh]

After posting this question on the MS SQL forums, I was told that there is no equivalent syntax for "(optional)" in SQL Server 2000.

Rather than spending hours tweaking the scripts, I had to manually scan the scripts and compare them to the existing SQL data/indices.  I commented out the lines that would have failed.  Took about 20-30 minutes.