Web Wiz Forums - New Topic error (ms sql)

New Topic error (ms sql)

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=28042
Printed Date: 02 April 2026 at 8:05am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: New Topic error (ms sql)

Posted By: Atvforum.dk
Subject: New Topic error (ms sql)
Date Posted: 18 November 2009 at 8:03pm

Hi.

I just upgraded to MS sql 2008.

It works fine, but when I want to create a new topic, this error shows:

Server Error in Forum Application
An error has occurred while writing to the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_save_new_topic_data
File Name:- new_post.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
The INSERT statement conflicted with the CHECK constraint "SSMA_CC$tblTopic$Icon$disallow_zero_length". The conflict occurred in database "atvforum_dk_db", table "dbo.tblTopic", column 'Icon'.

..................

When a user wants to create a account this error shows:

Support Error Code:- err_SQLServer_register_USR
File Name:- register.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
The INSERT statement conflicted with the CHECK constraint "SSMA_CC$tblAuthor$Skype$disallow_zero_length". The conflict occurred in database "atvforum_dk_db", table "dbo.tblAuthor", column 'Skype'.

How can I correct the errors?

Thank you for helping...

Replies:

Posted By: WebWiz-Bruce
Date Posted: 19 November 2009 at 8:43am

I have seen these issues before when you use the Microsoft SQL Server Migration Assistant 2008 for Access.

When you use this tool to upsize the database from Access to SQL Server it places in allot of extra constraints in the database which are not required.

To fix the issue follow the steps below:-

1. Open the database in SQL Server Management Studio 2008
2. Right click on each database table and select 'Design' from the menu
3. On the right hand side you will see the table design shown, Right click on anywhere there is white space in the same pane and select 'Check Constrains...'
4. In the Check Constraints window if there are any constraints listed for the table delete them
5. Once the Constraints are removed close the Constraints Window and Save the table

That should be it the database should be running fine after that, however you should also download the Database Optimsation Tool from the link below so that the important indexes are rebuilt:-
http://%20www.webwiz.net/webwizforums/webwizforums_downloads.asp" rel="nofollow -
http://www.webwiz.net/webwizforums/webwizforums_downloads.asp

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: Atvforum.dk
Date Posted: 19 November 2009 at 12:32pm

Ok, I'll try that.