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
Advertisements

Timeline

December 2017
M T W T F S S
« Mar    
 123
45678910
11121314151617
18192021222324
25262728293031

Blog Stats

  • 43,267 hits