asked
@@version differs from Discovery Report
I just installed SP2 and did a windows restart on my local pc. Now it looks like this: - SELECT @@version --result: Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) - SQL Server Installation Center->Discover Report: Version=10.52.4000.0 - installation-log wrote 10.50.4000.0 It is the same instance and always DB-Engine. Shouldn't these tool report the same version?
I don't use SSIC but did you run the report after installing and rebooting? There are multiple logs generated. Perhaps it is looking at a log before the final log is written? Maybe this link will help?
http://msdn.microsoft.com/en-us/library/ms143702.aspx
I run the report before rebooting and tried to fix the differing reported versions with a reboot afterwards. The Link sqlaj1 posted pionts to the directory "Setup Bootstrap\Log", there is a "Summary...txt" that gives the same Version as the HTML-Report. After SP2 I installed the latest cumulative Patch (I am hunting a bug), rebooted and compared again SELECT @@version with the Discovery Report now it is: @@version: 10.**50**.4286.0 DiscoveryReport: 10.**52**.4286.0
I've seen differences like this before, albeit in a different product - the Microsoft Assessment and Planning Toolkit (MAP). The reason given was that the MAP discovery was using registry keys to determine the version rather than directly from SQL (which presumably queries system tables). Not sure if that helps point you in the right direction?
14 People are following this question.
