Reset Password · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

Posted by: ablakov1 - Wednesday, 14 October 2009 08:42:40
Hello When i try to upgrade to 1.9.4 beta 2 i get the following message in installation page: [code]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][/code] I am using windows 2003 SP2 and SQL2000 SP4. Thanks

Posted by: ablakov1 - Wednesday, 14 October 2009 08:42:40

Hello When i try to upgrade to 1.9.4 beta 2 i get the following message in installation page: [code]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][/code] I am using windows 2003 SP2 and SQL2000 SP4. Thanks

Posted by: Jaben - Wednesday, 14 October 2009 14:03:06
It's this bug: 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?

Posted by: herman_herman - Wednesday, 14 October 2009 17:09:52
[quote=Jaben]It's this bug: 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?[/quote] Jaben, I think I have found a workaround for this but can't contact you via PM.Your Inbox is full.

Posted by: Jaben - Wednesday, 14 October 2009 17:17:55
[quote=herman_herman][quote=Jaben]It's this bug: 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?[/quote] Jaben, I think I have found a workaround for this but can't contact you via PM.Your Inbox is full. [/quote] Hmm... try now.

Posted by: Jaben - Wednesday, 14 October 2009 17:17:55

[quote=herman_herman][quote=Jaben]It's this bug: 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?[/quote] Jaben, I think I have found a workaround for this but can't contact you via PM.Your Inbox is full. [/quote] Hmm... try now.

Posted by: thebeloved - Friday, 16 October 2009 10:50:00
[quote=ablakov1]Hello When i try to upgrade to 1.9.4 beta 2 i get the following message in installation page: [code]FILE: mssql/views.sql ERROR: Invalid object name 'sys.views'. ... Thanks[/quote] 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

Posted by: herman_herman - Friday, 16 October 2009 13:49:13
For now you can try [url=http://forum.yetanotherforum.net/yaf_postst9283_SQL2000-Compatibility-Patch-for-rev-2755.aspx]this [/url]patch.please report back if there is any problem.

Important Information: