SQL Server version

[Igor]

Hi all,
Is there a way to find out SQL Server version(6.5, 7.0 or 2000) on the asp
page via VBScript, stored procedure or something else?
Thanks.
Igor

[Chris Hylton]

This is from the T-SQL online reference...it works...

@@VERSION
Returns the date, version, and processor type for the current installation
of Microsoft® SQL Server™.

Syntax
@@VERSION

Return Types
nvarchar

Remarks
The information returned by @@VERSION is similar to the product name, version,
platform, and file data returned by the xp_msver stored procedure, which
provides more detailed information.

Examples
This example returns the date, version, and processor type for the current
installation.

SELECT @@VERSION