Pages

Showing posts with label Ways to determine SQL Server version number. Show all posts
Showing posts with label Ways to determine SQL Server version number. Show all posts

Wednesday, June 19, 2013

Check SQL Server version information




1.
SELECT @@VERSION


2.
EXEC xp_msver

3.
SELECT
SERVERPROPERTY('productversion') AS ProductVersion,
SERVERPROPERTY ('productlevel') AS ProductLevel,
SERVERPROPERTY ('edition') AS ProductEdition