Quickly Get SQL Server Version, Edition and Update Level

This query works on SQL Server 2000 and above:

USE [master]
SELECT
CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - '
+ CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' ('
+ CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'

Wow. It's Quiet Here...

Be the first to start the conversation!

Leave a Reply:

Gravatar Image