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'))
Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!
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

Monday, July 07, 2008 3:38 AM by Smitha

# re: Determine SQL Server Version

good one..........

Leave a Comment

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