Skip to content

Instantly share code, notes, and snippets.

@oridonner

oridonner/SERVERPROPERTY.sql

Created August 22, 2016 08:06
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save oridonner/d850ebfa4196035efe5bae7fc1568510 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save oridonner/d850ebfa4196035efe5bae7fc1568510 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SERVERPROPERTY.sql
SELECT
SERVERPROPERTY('ProductLevel') AS ProductLevel,
SERVERPROPERTY('ProductUpdateLevel') AS ProductUpdateLevel,
SERVERPROPERTY('ProductBuildType') AS ProductBuildType,
SERVERPROPERTY('ProductUpdateReference') AS ProductUpdateReference,
SERVERPROPERTY('ProductVersion') AS ProductVersion,
SERVERPROPERTY('ProductMajorVersion') AS ProductMajorVersion,
SERVERPROPERTY('ProductMinorVersion') AS ProductMinorVersion,
SERVERPROPERTY('ProductBuild') AS ProductBuild
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment