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