When i try to upgrade to 1.9.4 beta 2 i get the following message in installation page:

FILE:
mssql/views.sql

ERROR:
Invalid object name 'sys.views'.

STATEMENT:
/*
** Views
*/

/****** Object:  View [dbo].[yaf_vaccess]    Script Date: 09/28/2009 22:26:00 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[yaf_vaccess]'))
DROP VIEW [dbo].[yaf_vaccess]

I am using windows 2003 SP2 and SQL2000 SP4.

Thanks

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126523 

Not totally sure about SQL Server 2k support going forward. Does anyone want to be a SQL Server 2k fixer for the project going forward?

Jaben,

I think I have found a workaround for this but can't contact you via PM.Your Inbox is full.

Hmm... try now.

I confirm that i have found similar error messages also in "constraint.sql", related to creation of primary index keys.

My hosting company also relies the db on SQLServer2000