Code to identify sql server version and edition  

Posted by: Quadtechindia in

Write following statement in Query Window

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

* The product version (10.0.1600.24)
* The product level (RTM)
* The edition (Enterprise)

Inorder to find out version of sql server write the following statements in query window


This entry was posted on Monday, February 01, 2010 and is filed under . You can leave a response and follow any responses to this entry through the Subscribe to: Post Comments (Atom) .


Post a Comment