There's Something about SQL!

...SQL Server, BI and other Cool Technology... var sc_project=1839145; var sc_invisible=1; var sc_partition=17; var sc_security="180bc290";

How to: Run MPS Reports (SQL) on SQL Server 2000 SP4

How to: Run MPS Reports (SQL) on SQL Server 2000 SP4

  • Comments 1
  • Likes
 

MPS Report is one of the standard tools used by Microsoft Support to facilitate the gathering of critical system and logging information (view).

 

If you run it on Microsoft SQL Server 2000 Service Pack 4 though, you'll receive a Buffer Overrun check dialog box, as in the following image:

 

This problem occurs because, when you install SQL Server 2000 SP4, the following registry key is modified for the default instance:

HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Setup

The character length value of this registry key is increased. However, the Sqldiag.exe utility does not support a larger value for this registry key.

 

What to do then? The workaround is fully described in this KB article (http://support.microsoft.com/kb/902955), and consists in nothing more than just ignore the message.

 

The consequences of the workaround are really few:  no impact the SQL Server service running on the server. The only consequence will be the lost of some (few) configuration files in the output of the utility.

Comments
  • Something I should have blogged about some time ago, to save time to myself to send out information when

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment