Ways to check SQL Server version number.

Vishalneeraj-24503
Posted by Vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 181
Method 1 –>
SELECT @@VERSION;


Method 2 ->
EXEC xp_msver


Method 3 ->
SELECT
SERVERPROPERTY('productversion') AS ProductVersion,
SERVERPROPERTY('productlevel') AS ProductLevel,
SERVERPROPERTY('edition') AS ProductEdition;

Comments or Responses

Login to post response