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.
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'
Basically, it was a simple misconception. Till date i thought @@version shows patch information of SQL Server, but actually it shows operating system patch.
@@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.
ReplyDelete