Data-tier application version storage at sql server level

• Tomasz M

  SSC-Addicted

  Points: 408

  More actions

  January 4, 2016 at 5:37 am

  #303540

  Is is possible to determine the version of Data-tier application that is deployed on sql server instance ?

  Where is the version number stored ?

• MadAdmin

  SSChampion

  Points: 11261

  More actions

  January 4, 2016 at 7:21 am

  #1849214

  Try [msdb].[dbo].[sysdac_history_internal] and [msdb].[dbo].[sysdac_instances_internal]

  Catch-all queries done right [/url]
  Gail Shaw's Performance Blog[/url]

• johnwalker10

  SSCrazy Eights

  Points: 9124

  More actions

  January 4, 2016 at 9:19 pm

  #1849439

  SELECT instance_name, type_version FROM msdb.dbo.sysdac_instances