How to determine SQL Server Product Version and Edition

0
21

Its easy to determine SQL Server Version and Edition from a single Query , for the same try the query below

 

SELECT SERVERPROPERTY(‘productversion’) as product_version, SERVERPROPERTY (‘productlevel’) as product_level, SERVERPROPERTY (‘edition’) as edition

 

Result

product_version  product_level  edition

10.50.1600.1   RTM   Standard Edition

LEAVE A REPLY

Please enter your comment!
Please enter your name here