SQL 2000 SP4 Enterprise Edition.

Posted on 2006-05-03
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

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
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    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

    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
    > Do you mean start Run?

    Run in Query Analyzer  

    Author Comment

    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

    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

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    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.

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now