FILE:

mssql/constraints.sql

ERROR:

For DROP INDEX, you must give both the table and the index name, in the form tablename.indexname.

content :

/* COMMENT OUT THE SQL BELOW FOR COMPATIBILITY WITH SQL SERVER 2000 */

/***** VIEWS ******/

/****** Object: Index [yaf_vaccess_user_UserForum] Script Date: 09/28/2009 22:30:20 ******/

IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[yaf_vaccess_user]') AND name = N'yaf_vaccess_user_UserForum_PK')

DROP INDEX [yaf_vaccess_user_UserForum_PK] ON [dbo].[yaf_vaccess_user]

help me! thanks

The Yet Another Forum version is ...

I using version

SQL Server 2000

YAF 1.9.4 RC

thanks

I had the same problem, the solution is in the text you posted.

Edit the script, re-run the installation.