Welcome to SqlAdvice Sign in | Join | Help

Determine SQL Server Version

If you need to know the version you are currently running of SQL Server you can easily get it by running the following query. 

SELECT 'SQL Server ' + CONVERT(varchar(100),SERVERPROPERTY('productversion')) + ' - ' + CONVERT(varchar(100),SERVERPROPERTY('productlevel')) + ' - ' + CONVERT(varchar(100),SERVERPROPERTY('edition'))
Sponsor
Published Wednesday, February 13, 2008 8:43 AM by gstark

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
required 
(required) 
Enter the code you see below