Web Wiz Support and Community Forums : need help for Sql Server version!!!! https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 07:27:25 +0000 Mon, 29 Dec 2003 07:12:16 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=8389 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[need help for Sql Server version!!!! : The file Web_Wiz_Forums_SQL.sql...]]> https://forums.webwiz.net/need-help-for-sql-server-version_topic8389_post43443.html#43443 Author: WebWiz-Bruce
Subject: 8389
Posted: 29 December 2003 at 7:12am

The file Web_Wiz_Forums_SQL.sql is only there for documentation purposes and should not be used to create the database.

Please follow the install instructions and you will find that there isa file called msSQL_server_setup.asp, you need to run this file tocreate the SQL server database with all default values and create adminaccounts etc.

You also need to enter your SQL server details in the connection filein the admin area, but this is all explained in the documentation.
]]> Mon, 29 Dec 2003 07:12:16 +0000 https://forums.webwiz.net/need-help-for-sql-server-version_topic8389_post43443.html#43443 <![CDATA[need help for Sql Server version!!!! : I have built a database using...]]> https://forums.webwiz.net/need-help-for-sql-server-version_topic8389_post43410.html#43410 Author: Zhiming
Subject: 8389
Posted: 28 December 2003 at 10:12pm

I have built a database using "Web_Wiz_Forums_SQL.sql" and imputing  data from access database. However, when

 

 I added forum category and new topics, there are some error messages Like this:

 

 

Microsoft OLE DB Provider for SQL Server (0x80040E2F)

无法将 NULL 值插入列 'Moved_ID'，表 'wwf.dbo.tblTopic' ；该列不允许空 540;。INSERT 失败。

/wwf/post_message.asp, 第 614 行

 

I know this is field default value not assigned,I try assign them. but next error message

 

Came up:

 

ADODB.Recordset (0x800A0CB3)

当前记录集不支 345;更新。这可能是 提供程序的限制A 292;也可能是选定锁 定类型的限制。

/wwf/post_message.asp, 第 746 行

 

This is because of SQL string used "order by" and "top 1"

&n]]> Sun, 28 Dec 2003 22:12:53 +0000 https://forums.webwiz.net/need-help-for-sql-server-version_topic8389_post43410.html#43410