2014-03-04

How to know which SQL Server version and edition you are running

SELECT @@VERSION AS [Version]
Will return something like:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Express Edition with Advanced Services (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) 
Found it here.

No comments:

Post a Comment