Vulnerability Note VU#700575

Buffer overflows in Microsoft SQL Server 7.0 and SQL Server 2000

Original Release date: 21 Dec 2001 | Last revised: 09 Jan 2002


There is a buffer overflow in Microsoft SQL Server 2000 and SQL Server 7.0 which could allow an intruder to execute arbitrary code on vulnerable systems.


Microsoft Windows SQL Server 2000 and SQL Server 7.0 contain a buffer overflow in functions associated with text messages. For more information, see

Quoting from MS01-060,

The functions that contain the unchecked buffers are associated with creating, and in some cases displaying, text messages. SQL Server provides several functions that enable a database query to create formatted text.

Intruders who can execute queries containing these functions can exploit a buffer overflow. An intruder who could load and execute queries of his own choosing would be able to exploit this vulnerability. Other intruders may be able to execute this vulnerability as well. Again, quoting from MS01-060,

If the database search [or other routine] called one of the affected functions, it might be possible for an attacker to construct a query that would cause [an affected] function to be called in such a way as to exploit the vulnerability. Clearly, this would require intimate knowledge of the internals of the database query.

On the other hand, if the database query were poorly implemented, the attacker might not need to know its internal details in order to exploit the vulnerability. One frequently exploited implementation error occurs when a database query doesn’t adequately check its inputs before using them. In some cases, this would make it possible for an attacker to embed database commands – including, in this case, calls to the affected functions – within database query parameters. This underscores the need to always check input parameters before using them.

Applying the patch protects against all these attack scenarios, though it is still wise to ensure that input parameters to SQL Server queries are closely examined to guard against other possible vulnerabilities or unauthorized access.


Intruders can execute arbitrary code with the privileges of the SQL server process.


Apply a patch as described in MS01-060.

Systems Affected (Learn More)

VendorStatusDate NotifiedDate Updated
MicrosoftAffected-21 Dec 2001
If you are a vendor and your product is affected, let us know.

CVSS Metrics (Learn More)

Group Score Vector
Base N/A N/A
Temporal N/A N/A
Environmental N/A N/A



Our thanks to Microsoft for the information contained in their bulletin. Microsoft has publicly thanked Chris Anley of @Stake for reporting this issue to them.

This document was written by Shawn V. Hernan.

Other Information

  • CVE IDs: CAN-2001-0542
  • Date Public: 20 Dec 2001
  • Date First Published: 21 Dec 2001
  • Date Last Updated: 09 Jan 2002
  • Severity Metric: 15.19
  • Document Revision: 7


If you have feedback, comments, or additional information about this vulnerability, please send us email.