Thursday 6 December 2012

How to check db internal version

Execute the following command from sql server management studio Query window:-
select DATABASEPROPERTY((select DB_Name()),'Version')
------------------------------------------------------------------------------------------------------------
SELECT SERVERPROPERTY('productversion') as [Product version],
SERVERPROPERTY ('productlevel') as [Product level] ,
SERVERPROPERTY ('edition') as [Edition],
DATABASEPROPERTYEX((select DB_Name()),'Version') as [Internal Version Number]
,DATABASEPROPERTY((select DB_Name()),'Version') as [Internal Version Number--Deprecated]
,(select DB_Name()) as DBName,
(SELECT COMPATIBILITY_LEVEL FROM SYS.DATABASES WHERE NAME = (select DB_Name())) as compatibilityLevel

No comments:

Post a Comment