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

Notification

Icon
Error

Options
Go to last post Go to first unread
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 .
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
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 .
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
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 :?
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
Users browsing this topic
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.