• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 605
  • Last Modified:

How do I set the expression services limit in SQL 2005?

Is there a way to set the Expression Services limit in SQL 2005?
0
JSB1996
Asked:
JSB1996
2 Solutions
 
QPRCommented:
The limit is set to 65,535
You want to raise/lower this limit? I don't know of a way to do so.
0
 
Eugene ZCommented:
you need to  rewrite your query.

see more:
"Error message when you run a query in SQL Server 2005: "Internal error: An expression services limit has been reached" "
http://support.microsoft.com/kb/913050
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now