You can use the following sql statements to know the Sql Server Version:
SELECT @@VERSION AS SQLVERSION
/*Gives the complete information of sql edition and version*/SELECT SERVERPROPERTY('ProductVersion')AS SqlVersion, SERVERPROPERTY('Edition')AS SqlEdition, SERVERPROPERTY('ServerName')AS SQLServerName
SELECT 'Microsoft SQL Server ' + CAST(SERVERPROPERTY('EDITION')AS VARCHAR(100)) + ' ' + CAST(SERVERPROPERTY('PRODUCTLEVEL')AS VARCHAR(50)) AS SqlServerVersion
You can use the other values to know more information using SERVERPROPERTY function.
You can also use the following stored procedures to know the Sql Server version Information.
EXEC xp_msver
EXEC sp_msGetVersion
No comments:
Post a Comment