SQLRockstar on Mon, 09 Sep 2019 22:18:22
Try using the AWBuildVersion table included inside of AdventureWorks and see if that has the details you need. HTH
rootsmusic on Mon, 09 Sep 2019 22:27:29
Try using the AWBuildVersion table included inside of AdventureWorksAWBuildVersion.csv, which is in the OLTP install script but not the other install script, lists OLTP's build number as 13.0.1601.5. However, which version of the AdventureWorks release does that build number correspond?
Jefferson Silva DBA on Tue, 10 Sep 2019 00:42:12
Come on. The first option shows Azure Database, which will always be in the latest stable release. Have your stable database updated.
Csv is version 13.0.1601.5 which is a Sql Server 'SQL Server 2016 RTM'.
The DW script says:
Summary: Creates the AdventureWorksDW sample database. Run this on
any version of SQL Server (2008R2 or later) to get AdventureWorksDW for your current version.
If in doubt run the query below to see which version is installed: