Web Wiz Forums - SQL Server Error on delete

Print Page | Close Window

SQL Server Error on delete

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=17131
Printed Date: 16 April 2026 at 6:30am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL Server Error on delete

Posted By: bruce
Subject: SQL Server Error on delete
Date Posted: 03 November 2005 at 4:53pm

I've been struggling with this problem for awhile now and I'm at my wits end.

Forum: WWF v7.95
DB: SQL

Host: JodoHost

Every time I delete a post from my forum I get the follow error:

Microsoft OLE DB Provider for SQL Server error '80040e14'

The query has been canceled because the estimated cost of this query (327) exceeds the configured threshold of 200. Contact the system administrator.
/gfboard/delete_post.asp, line 217

I thought I had it figured out. The error used to say that I exceeded the estimated cost of the query (192) and that the server was only configured for (60), so I had jodohost configure the SQL server for 200.

So now the server is configured for 200 and now I get the above error in red.

Replies:

Posted By: JJLatWebWiz
Date Posted: 03 November 2005 at 5:46pm

I worked on http://forums.webwiz.net/forum_posts.asp?TID=16705#91763 - a simple solution that the only other reporting user hasn't had a chance to test yet... Try adding "adoCon.CursorLocation = 3" immediately above "adoCon.open" in "common.asp".

I'm interested to hear if the suggestion solves the problem.

-------------
p.s. I'm not affiliated with Web Wiz Guide in any way. I'm just an average Web Wiz user repaying my debt for the use of their fine forum by trying to help other Web Wiz Guide users.

Posted By: bruce
Date Posted: 03 November 2005 at 6:06pm

Turning off the query governor on the SQL Server resolved this problem.

Posted By: JJLatWebWiz
Date Posted: 03 November 2005 at 8:15pm

Darn. I wanted to see if the client-side cursor worked. Oh well.

Keep in mind that the governor protects your SQL queries from other host clients that may hog the SQL server. The client-side cursor is much more efficient on the SQL server too.

I'm surprise a host would shut if off.

-------------
p.s. I'm not affiliated with Web Wiz Guide in any way. I'm just an average Web Wiz user repaying my debt for the use of their fine forum by trying to help other Web Wiz Guide users.