Presents your 
SQL SERVER E-NEWSLETTER for November 7, 2002

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

DETERMINE WHAT EDITION IS RUNNING

There are several ways to determine what edition of SQL Server is
running on a particular installation. Here is a list of some of the 
options, starting with the easiest:


* SELECT @@VERSION

* SELECT SERVERPROPERTY('Edition')

* Navigate in SQL Enterprise Manager (SEM) to the server in question.
Highlight the server, right-click on the server, and select Properties 
from the pop-up menu. In the General tab, it should be labeled which
"Product" is installed.

* Run the sqldiag utility and check the output file.


The global variable @@VERSION will return the SQL Server version,
edition, and service pack information.

The SERVERPROPERTY function was introduced in SQL Server 2000. The
argument, Edition, will report the edition, specifying one of the 
following:
Desktop, Developer, Enterprise, Enterprise Evaluation, Personal, or
Standard. The service pack information is also reported. (Note that if 
the default instance is not SQL Server 2000, this function is not 
available.)

The output file generated from the sqldiag utility has the same
information as the @@VERSION global variable. This information is 
listed at the top of the sqldiag utility's output file. You can run the following
command to generate the output file:

EXEC master..xp_cmdshell 'sqldiag'

The output will be similar to the following:

output                                      
---------------------------------------------
Getting file E:\MSSQL7\log\ERRORLOG
Getting file E:\MSSQL7\log\ERRORLOG.1
Getting file E:\MSSQL7\log\ERRORLOG.2
Getting file E:\MSSQL7\log\ERRORLOG.3
Getting file E:\MSSQL7\log\ERRORLOG.4
Getting file E:\MSSQL7\log\ERRORLOG.5
Getting file E:\MSSQL7\log\ERRORLOG.6
Getting registry information
Getting library version information
Connecting to server
Getting last 100 queries
Getting configuration information
Getting current user information
Getting lock information
Getting database information
Getting product information
Getting extended procedures information
Getting process information
Getting input buffers
Getting deadlocks
Getting machine information
Data Stored in E:\MSSQL7\log\SQLdiag.txt
*** Unable to open file E:\MSSQL7\log\ERRORLOG.3 ***
*** Unable to get last 100 queries ***
*** Unable to open file SERVER7.txt ***
NULL

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