Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
SQL Server 2008 126
SQL Server 2005 109
TSQL Tips n Tricks 80
Performance Tuning 57
SQL Server 2012 48
SQL Server Basics 24
Sql Server Management 21
SSMS 21
Index 18
SQL Server Denali 13

Archive · View All
March 2011 24
December 2010 23
January 2011 22
May 2011 17
February 2011 16
April 2011 16
July 2012 12
August 2011 9
September 2012 8
August 2012 8

SQL Server : @@VERSION Showing Incorrect Service Pack Information

Jul 26 2012 2:55PM by aasim abdullah   


Recently, due to SQL Server Log message The time stamp counter of CPU on scheduler id 13 is not synchronized with other CPUs. we have decided to resolve it by installing Service Pack 3 for SQL Server 2005. To confirm, that target server has version prior to Service Pack 3, I have used following simplest query.
SELECT@@VERSION
From query result it became sure that said server has Service Pack 2 installed and need to be upgraded to Service Pack3. 
On receiving confirmation mail from Systems department that said instance is upgraded, I went for same above query to verify and surprisingly, it was still showing the same result with Service Pack 2.
For further confirmation I have used a different query (SERVERPROPERTY('PRODUCTLEVEL') and found actual results (i.e. Service Pack 3). 

 In future, I am not going to trust on @@VERSION for Service Pack investigation ;).

Tags: Sql Server 2005,SQL Server Errors,SQL Server Basics


aasim abdullah
23 · 7% · 2373
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 



Submit

3  Comments  

  • @@VERSION doesn't return the SQL Server patch level! It returns the OS/host patch level. Documented at: http://msdn.microsoft.com/en-us/library/ms177512.aspx and http://support.microsoft.com/kb/321185.

    commented on Jul 26 2012 5:51PM
    Nakul Vachhrajani
    4 · 36% · 11645
  • @Aasim:- Last line (after ON) returned from @@version is OS information not the SQL server information. @@Version just returns the correct build number.

    commented on Nov 30 2012 12:03AM
    Chintak Chhapia
    40 · 5% · 1470
  • You can use the build number 9.00.4035.00 and look for the service pack version. Don't know who is maintaining this site, but found this really useful and also updated regularly

    http://sqlserverbuilds.blogspot.in/

    commented on Nov 30 2012 12:07AM
    Chintak Chhapia
    40 · 5% · 1470

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]