OpenQuery character limit


  • I am executing an MDX query from T-SQL.  I am using OpenQuery, and there is a need to allow the query to go beyond 4 or even 8 thousand character limit as it includes a number of query scoped calculated members that encapsulate business logic.    How can I go beyond this limit without much trouble?  Suggestions are very welcome


    Javier Guillen
    Wednesday, December 15, 2010 3:28 AM


  • Unless you can do multiple separate queries within the limit of 8K, I don't see a way as the limitation is stated in the BOL.
    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    • Marked as answer by KJian_ Wednesday, December 22, 2010 5:04 AM
    Wednesday, December 15, 2010 3:36 AM