SQL 2000 SP4 Enterprise Edition.

Posted on 2006-05-03
Medium Priority
Last Modified: 2008-01-09
I have a Windows 2003 Std Edition Server Running MS SQL 2000 Enterprise Edition SP4.  I am getting the following error in the EventViewer / Application Log.

Event Type:      Information
Event Source:      MSSQLSERVER
Event Category:      Server
Event ID:      17055
Date:            5/4/2006
Time:            12:28:40 AM
User:            N/A
Computer:      NABUEPO01
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 2 queries and performance may be adversely affected.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

0000:  9c 42 00 00 0a 00 00 00   œB......
0008:  0a 00 00 00 4e 00 41 00   ....N.A.
0010:  42 00 55 00 45 00 50 00   B.U.E.P.
0018:  4f 00 30 00 31 00 00 00   O.0.1...
0020:  07 00 00 00 6d 00 61 00   ....m.a.
0028:  73 00 74 00 65 00 72 00   s.t.e.r.
0030:  00 00                     ..

This server is running Mcafee EPO Server.  Originally it was running MSDE SQL 4, but my DB has grown beyond the 2GB limit of MSDE and I have removed MSDE and installed the full version of SQL.  My DB being beyond the 2GB MSDE limit is another issue altogether I just want to solve these constant entries I see in the Eventviewer.

Can Anyone Help?
Question by:shanewilson6002
  • 3
  • 2
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 16602914
Usually this kind of problem comes with MSDE and MS Sql person editions, once you install the Enterprise edition, this will disappear.
I hope in enterprise edition also the problem can occur, if you have some licensing problems.

Run this to makesure that you are having the enterprise edition
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Author Comment

ID: 16602967
Sorry I am a little anept when it comes to things like RUN.  Do you mean start Run?

Can you please give an example?
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 16602985
> Do you mean start Run?

Run in Query Analyzer  

Author Comment

ID: 16604617
Okay this is a little bit out of my SQL relm.  I need to know exactly how to do this..... PLS.
LVL 75

Accepted Solution

Aneesh Retnakaran earned 1000 total points
ID: 16605172
Start -> programs-> Microsoft SQL Server -> Quey analyser

Enter the username and password

then in the New window , paste this

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

then press F5, You can see the results in the result pane, copy that and send to me

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question