seanism DOT com Random thoughts from the world of seanism


How to identify your SQL Server version and edition

To find out your version of SQL download/install/open Microsoft SQL Server Management Studio Express then click New Query

Paste the below code in the query pane on the right
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
and click Execute

In the results window it will display the version, Service Pack, and edition.

For older versions refer to the command and chart on the Microsoft KB 321185.

Comments (0) Trackbacks (0)

No comments yet.

Leave a comment

No trackbacks yet.