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

October 2017
M T W T F S S
« Mar    
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

Blog Stats

  • 42,939 hits