Web Wiz Support and Community Forums : SQL Server Error on delete https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 16 Apr 2026 02:59:12 +0000 Thu, 03 Nov 2005 20:15:55 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=17131 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[SQL Server Error on delete : Darn. I wanted to see if the...]]> https://forums.webwiz.net/sql-server-error-on-delete_topic17131_post93261.html#93261 Author: JJLatWebWiz
Subject: 17131
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.]]> Thu, 03 Nov 2005 20:15:55 +0000 https://forums.webwiz.net/sql-server-error-on-delete_topic17131_post93261.html#93261 <![CDATA[SQL Server Error on delete : Turning offthe query governor...]]> https://forums.webwiz.net/sql-server-error-on-delete_topic17131_post93256.html#93256 Author: bruce
Subject: 17131
Posted: 03 November 2005 at 6:06pm

Turning off the query governor on the SQL Server resolved this problem.]]> Thu, 03 Nov 2005 18:06:11 +0000 https://forums.webwiz.net/sql-server-error-on-delete_topic17131_post93256.html#93256 <![CDATA[SQL Server Error on delete : I worked on a simple solution...]]> https://forums.webwiz.net/sql-server-error-on-delete_topic17131_post93254.html#93254 Author: JJLatWebWiz
Subject: 17131
Posted: 03 November 2005 at 5:46pm

I worked on 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.]]> Thu, 03 Nov 2005 17:46:34 +0000 https://forums.webwiz.net/sql-server-error-on-delete_topic17131_post93254.html#93254 <![CDATA[SQL Server Error on delete : I&#039;ve been struggling with...]]> https://forums.webwiz.net/sql-server-error-on-delete_topic17131_post93244.html#93244 Author: bruce
Subject: 17131
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.
]]> Thu, 03 Nov 2005 16:53:44 +0000 https://forums.webwiz.net/sql-server-error-on-delete_topic17131_post93244.html#93244