how can I tell what version of SQL Server is running?

[mb224]

how can I tell what version of SQL Server is running? Isn't there a stored procedure?

 

[SQLSister]

SELECT @@VERSION


Questions about posting. See faq183-874

 

[mb224]

thanks

 

[mrdenny]

This will give you some better info if you are running SQL 2000.

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

Denny

--Anything is possible. All it takes is a little research. (Me)