You are currently browsing the tag archive for the ‘“sql server” tips’ tag.

Use this query to verify the details on the SQL Server:

SELECT
SERVERPROPERTY(‘ProductVersion’) AS ProductVersion,
SERVERPROPERTY(‘ProductLevel’) AS ProductLevel,
SERVERPROPERTY(‘Edition’) AS Edition;

Of course, there are other ways, but the above is the most ‘coherent’.

Other convenientĀ methods:

  • SELECT @@VERSION
  • Check the file version of sqlservr.exe

Timeline

August 2017
M T W T F S S
« Mar    
 123456
78910111213
14151617181920
21222324252627
28293031  

Blog Stats

  • 42,577 hits