Sql Server Error

[FoFa]

In the event log on one server we are getting this:

Error code: 17052: This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected

Now anything I can find on this says it has to do with MSDE.
Yet it is Standard edition, SP4 running on WIN 2000 server.
Any ideas any one?

 

[SQL_Hell]

Hi

Try setting the MAXDOP to 0 to run all processes in series, that will stop the error.
But this is more likely down to a bad peice of code somewhere, do you have any idea which query is causing the problem?

 

[FoFa]

Hi

Try setting the MAXDOP to 0 to run all processes in series, that will stop the error.
But this is more likely down to a bad peice of code somewhere, do you have any idea which query is causing the problem?

No, it is a vendor supplied application and this server only handles it.