SQL 2005 Query Error Options  Email this topic  Watch this topic  Print this topic » Normal Threaded

Previous Topic Next Topic

tareq		#1 Posted : Sunday, July 16, 2006 6:47:53 PM(UTC)
Rank: Member Reputation: Groups: Member Joined: 5/20/2006(UTC) Posts: 15		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 .
User Profile View All Posts by User View Thanks

	Wanna join the discussion?! Login to your HostingFest Forums forum account, or Register a new forum account.

Smiling4ever		#2 Posted : Sunday, July 16, 2006 9:39:49 PM(UTC)
Rank: Administration Reputation: Groups: Administration, Member Joined: 1/3/2006(UTC) Posts: 348 Was thanked: 1 time(s) in 1 post(s)		How did you run the query?
		Noman Dormosh HostingFest
		WWW
User Profile View All Posts by User View Thanks

tareq		#3 Posted : Sunday, July 16, 2006 9:54:42 PM(UTC)
Rank: Member Reputation: Groups: Member Joined: 5/20/2006(UTC) Posts: 15		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 .
User Profile View All Posts by User View Thanks

Smiling4ever		#4 Posted : Sunday, July 16, 2006 10:30:26 PM(UTC)
Rank: Administration Reputation: Groups: Administration, Member Joined: 1/3/2006(UTC) Posts: 348 Was thanked: 1 time(s) in 1 post(s)		Can you try that now again...?
		Noman Dormosh HostingFest
		WWW
User Profile View All Posts by User View Thanks

tareq		#5 Posted : Sunday, July 16, 2006 11:35:38 PM(UTC)
Rank: Member Reputation: Groups: Member Joined: 5/20/2006(UTC) Posts: 15		Senior Developer wrote: Can you try that now again...? The Same error :?
User Profile View All Posts by User View Thanks

Smiling4ever		#6 Posted : Wednesday, July 19, 2006 12:35:53 AM(UTC)
Rank: Administration Reputation: Groups: Administration, Member Joined: 1/3/2006(UTC) Posts: 348 Was thanked: 1 time(s) in 1 post(s)		Raise a ticket please
		Noman Dormosh HostingFest
		WWW
User Profile View All Posts by User View Thanks

Users browsing this topic

Guest (3)