September 2, 2009 at 6:40 am
I have SQL Server 2005 SP2. Now i tried to install Sp3 for SQL Server 2005. the installation was successful and since i did not stop any services i did a restart and when i tried to check the service pack by using command "select @@Version" i see the same SP2 there.
by seeing the server properties i see that SP3 has been installed it shows "SQL Server 9.0.4035".but cannot see when i run the above command. any ideas what wrong? help me please.
September 2, 2009 at 7:05 am
I doubt anything's wrong, the SP2 you're refering to is going to be the OS version, not the SQL Server version.
September 2, 2009 at 7:17 am
So when I run
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
It give the output as
9.00.4035.00 SP3 Developer Edition that is good.
But when I run
select @@Version
It give the output as
Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 6.0 (Build 6002: Service Pack 2)
So at the end (Build 6002: Service Pack 2) that I see is not for SQL Server right? Its for windows right? So the first command is fine right?
September 2, 2009 at 7:26 am
Yes, the second line is the Windows SP.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
September 2, 2009 at 7:27 am
ok thanks a lot. i was confused by that.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply