home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 19,505 of 19,505   
   Erland Sommarskog to Anton Shepelev   
   Re: Error: Server stack limit has been r   
   13 Feb 26 11:08:16   
   
   From: esquel@sommarskog.se   
      
   Anton Shepelev (anton.txt@g{oogle}mail.com) writes:   
   > Hello, all   
   >   
   > I am getting the following error from a third-party   
   > application:   
   >   
   >    Microsoft SQL Native Client 11.0:   
   >    Server stack limit has been reached.   
   >    Please look for potentially deep nesting in your query,   
   >    and try to simplify it.   
   >   
   > Yet I cannot seem to find a way to increase that limit.   
   > This occurs on MSSQL 13.0.1601.5, whereas the only   
   > mention of this error is in a bug fixed for a prior   
   > version:   
   >   
   >      
   >   
   > What are my options, then? -- contact the product's tech   
   > support?   
      
   A start would be to apply Service Pack 3 for SQL 2016. It may help. In any   
   case, you should not run with the RTM version of SQL 2016.   
      
   You could also upgrade to a of SQL Server that is in mainstream support,   
   that is SQL 2022 or SQL 2025. That presumes that the vendor support that   
   version. Then you could open a case directly with Microsoft.   
      
   But it may be better to open a case with the product vendor and let them   
   have the discussions with Microsoft. Of course, this assumes that the   
   vendor still support the version of the product that you are using.   
      
   I guess that one way to increase the stack limit is to slap on more RAM.   
   But that will not help if this is a case of infinite recursion or similar.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca