SQL to find out version of SQL Server running? 1

[hvisionexpo]

Is there a way to query the verson of SQL Server the user is running?

e.g. SQL 2000 or SQL 2005

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

Presently we have app deployed in 2000 and plan to silently upgrade users to 2005. would like to chek whether they need to be upgraded ornot. some clients are already on 2005.

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

THANKS

 

[ptheriault]

SELECT @@version

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[ptheriault]

You can also run this which give you. product version, service pack and edition.

SELECT 'SQL Server ' 
+ CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - ' 
+ CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' (' 
+ CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'

SELECT LTRIM(RIGHT(LEFT(@@VERSION,38),9))

select @@version

- Paul
- If at first you don't succeed, find out if the loser gets anything.