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?

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?

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.