What Version / Service Pack of SQL Server am I Running?


Here’s a handy little script which tells you what version, service pack and edition of SQL Server you’re running.

It’s best to display results as “Text” rather than the “Grid”.

   SELECT   @@VERSION
   SELECT   RTRIM(CAST(SERVERPROPERTY('productversion') AS VARCHAR)) AS [Version],
            RTRIM(CAST(SERVERPROPERTY ('productlevel') AS VARCHAR)) AS [Level],
            RTRIM(CAST(SERVERPROPERTY ('edition') AS VARCHAR)) AS [Edition]
SQL Server Version Information
SQL Server Version Information

Published by

Phil Harding

SharePoint Consultant, Developer, Father, Husband and Climber.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s