FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally Have (299717)

RESOLUTION

SQL Server 2000

To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
If you are running SQL Server 2000 without any Service Packs, the individual hotfix is available from the Microsoft Download Center: The s80296i.exe file contains the following files:

   File name      Size         Date
   -------------------------------------
   Sqlservr.exe   7,458,877    5/22/2001
   Sqlservr.pdb   12,510,208   5/22/2001
   Readme.txt     4,205        5/22/2001
				

Release Date: MAY-25-2001

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base: Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

SQL Server 7.0

To resolve this problem, obtain the latest service pack for Microsoft SQL Server 7.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base: NOTE: The following hotfix was created prior to Microsoft SQL Server 7.0 Service Pack 4.

A supported fix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Apply it only to computers that you determine are at risk of attack. Evaluate your computer's physical accessibility, network and Internet connectivity, and other factors to determine the degree of risk to your computer. See the associated Microsoft Security Bulletin to help determine the degree of risk. This fix may receive additional testing. If your computer is sufficiently at risk, Microsoft recommends that you apply this fix now. Otherwise, wait for the next SQL Server 7.0 service pack that contains this fix.

To resolve this problem immediately, download the fix by following the instructions later in this article or contact Microsoft Product Support Services to obtain the fix. For a complete list of Microsoft Product Support Services phone numbers and information about support costs, visit the following Microsoft Web site:NOTE: In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

The following files are available for download from the Microsoft Download Center:
The s70996i.exe (Intel x86) file contains the following files:

   File name      Size        Date
   ------------------------------------
   Sqlservr.exe   5,054,736   5/23/2001
   Sqlservr.dbg   4,359,392   5/23/2001
   Sqlservr.pdb   3,580,928   5/23/2001
   Sqlsort.dll    586,000     1/14/2001
   Readme.txt     4,890       5/23/2001
				

The s70996a.exe (Alpha) file contains the following files:

   File name      Size        Date
   ------------------------------------
   Sqlservr.exe   11,664,656  5/23/2001
   Sqlservr.dbg   13,463,184  5/23/2001
   Sqlservr.pdb   5,686,272   5/23/2001
   Sqlsort.dll    593,169     1/14/2001
   Readme.txt     4,874       5/31/2001
				

Release Date: MAY-25-2001

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base: Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.