Presents your 
SQL SERVER E-NEWSLETTER for September 17, 2002

<------------------------------------------->

USE THE EXTENDED PROCEDURE XP_MSVER

You can use the extended procedure xp_msver to capture the detailed
information for your SQL Server configuration. System configuration
information is good to have on hand in several situations, including:

* Making support calls to Microsoft Support
* Keeping an inventory of SQL Server configurations
* Keeping a history of server upgrades
* Scheduling servers that need an upgrade

If there is no option parameter specified when executing xp_msver, it
will return all options that it can find. This procedure will help you find
out the hardware specifications on the server, such as the processor
count and amount of memory. It's one of the procedures that the sqldiag
utility calls to retrieve this information.

Here's a script without a specified option parameter, which will
therefore report all known options.

exec master..xp_msver

Please note that there's a known bug with this extended procedure for
SQL Server 2000. However, the bug is only applicable to non-English SQL
Server installations, and the patch should not be applied unless that
specific situation applies to your environment.

----------------------------------------