How to determine SQL Server Product Version and Edition

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

abhilash

abhilash, is a programmer by profession and a technology addict with a passion towards browsing , shopping and imaging . My views may be biased on reviews. all images and videos are copyrighted to respective owners.

Add comment

Your Header Sidebar area is currently empty. Hurry up and add some widgets.