Microsoft Windows SQL Server allows arbitrary queries to be executed via "xp_displayparamstmt" extended procedure

ID VU:818939
Type cert
Reporter CERT
Modified 2002-08-16T00:00:00



MS SQL Server contains an extended stored procedure with inappropriate permission settings.


Microsoft SQL Server 7.0 and Microsoft SQL Server 2000 contain an extended stored procedure, xp_displayparamstmt, that permits an unprivileged user of a database to gain administrative access to the database. For more information, please see

<> and

This vulnerability was discovered David Litchfield of NGSSoftware.


An intruder can gain administrative access to a vulnerable SQL Server database.


Apply a patch as described in <>.

Systems Affected

Vendor| Status| Date Notified| Date Updated
Microsoft Corporation| | -| 16 Aug 2002
If you are a vendor and your product is affected, let us know.

CVSS Metrics

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


  • <>
  • <>


Thanks to David Litchfield for reporting this vulnerability.

This document was written by Shawn V Hernan.

Other Information

  • CVE IDs: CAN-2002-0721
  • Date Public: 16 Aug 2002
  • Date First Published: 16 Aug 2002
  • Date Last Updated: 16 Aug 2002
  • Severity Metric: 12.66
  • Document Revision: 3