Skip to content

Instantly share code, notes, and snippets.

@jeffjohnson9046

jeffjohnson9046/sql-server-product-info.sql

Created December 23, 2015 07:51
Show Gist options
  • Save jeffjohnson9046/605e649683a09fb13079 to your computer and use it in GitHub Desktop.
Save jeffjohnson9046/605e649683a09fb13079 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Server Product Information
Raw
sql-server-product-info.sql
/* Run this query against any database on a SQL Server instance to get version details*/
SELECT
SERVERPROPERTY('productversion') AS ProductVersion,
SERVERPROPERTY('productlevel') AS ProductLevel,
SERVERPROPERTY('edition') AS Edition,
@@VERSION AS VerboseVersion;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment