logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
SQL 2005 Query Error
Options
Go to last post Go to first unread
Previous Topic Next Topic
tareq  
#1 Posted : Sunday, July 16, 2006 6:47:53 PM(UTC)
tareq
Rank: Member

Reputation:

Groups: Member
Joined: 5/20/2006(UTC)
Posts: 15
Man
I have a query with three subqueries it was working well in SQL Server 2000 (personal,enterprise) but now am facing the following error in SQL2005

(The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. )

Also it is not complex and it was running on PC with 500 MHz processor & 125 MB Ram .


Any help or suggestions with this .
Back to top

Wanna join the discussion?! Login to your HostingFest Forums forum account, or Register a new forum account.
Back to top  
Smiling4ever  
#2 Posted : Sunday, July 16, 2006 9:39:49 PM(UTC)
Smiling4ever
Rank: Administration

Reputation:

Groups: Administration, Member
Joined: 1/3/2006(UTC)
Posts: 348
Man

Was thanked: 1 time(s) in 1 post(s)
How did you run the query?
Noman Dormosh

HostingFest
Back to top
WWW
tareq  
#3 Posted : Sunday, July 16, 2006 9:54:42 PM(UTC)
tareq
Rank: Member

Reputation:

Groups: Member
Joined: 5/20/2006(UTC)
Posts: 15
Man
From My website & from SQL server managment studio through calling a stored procedure .

Note : The SQL statement is dynamic which is build on the fly .
Back to top
Smiling4ever  
#4 Posted : Sunday, July 16, 2006 10:30:26 PM(UTC)
Smiling4ever
Rank: Administration

Reputation:

Groups: Administration, Member
Joined: 1/3/2006(UTC)
Posts: 348
Man

Was thanked: 1 time(s) in 1 post(s)
Can you try that now again...?
Noman Dormosh

HostingFest
Back to top
WWW
tareq  
#5 Posted : Sunday, July 16, 2006 11:35:38 PM(UTC)
tareq
Rank: Member

Reputation:

Groups: Member
Joined: 5/20/2006(UTC)
Posts: 15
Man
Senior Developer wrote:
Can you try that now again...?


The Same error :?
Back to top
Smiling4ever  
#6 Posted : Wednesday, July 19, 2006 12:35:53 AM(UTC)
Smiling4ever
Rank: Administration

Reputation:

Groups: Administration, Member
Joined: 1/3/2006(UTC)
Posts: 348
Man

Was thanked: 1 time(s) in 1 post(s)
Raise a ticket please
Noman Dormosh

HostingFest
Back to top
WWW
Users browsing this topic
Guest (3)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Privacy Policy | Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.341 seconds.