February 16, 2010 at 2:25 am
Hi All,
I run the query :-
select @@Version
and it gives me the result as :-
Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
and if I run this query :-
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
8.00.2040SP4Enterprise Edition
which one is giving me correct detail and why not other??????? :angry: :angry: :angry: :angry:
----------
Ashish
February 16, 2010 at 2:54 am
both are correct
in the first query o\p
Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) (Windows Service pack)
in second query o\p
8.00.2040 SP4 Enterprise Edition
(SQL Service Pack)
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
February 16, 2010 at 3:11 am
The question was about service pack difference in query result.....
----------
Ashish
February 16, 2010 at 3:20 am
thats what i replied
first query gives u windows operating system service pack
second query gives u sql server service pack.
why?
thats how microsoft has liked to do the things.
if u r a professional DBA by looking at version no. u can get the idea of SP
refer
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
for latest SPs
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
February 16, 2010 at 3:43 am
Thanks Sanket for the link...gr8 site
February 16, 2010 at 4:18 am
ohhh great. Thanks for reply...... I am truly not professional....left the crown for you....:w00t::w00t::w00t::w00t::w00t:
----------
Ashish
February 19, 2010 at 3:39 am
ashish.kuriyal (2/16/2010)
I run the query :-select @@Version
and it gives me the result as :-
Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
and if I run this query :-
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
8.00.2040SP4Enterprise Edition
which one is giving me correct detail and why not other?
I can't see any difference in SQL Server versions there :blink:
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
February 19, 2010 at 5:35 am
Paul,
His question was regarding difference in service pack level as he got confused with OS pack level and SQL SP Level.
MJ
February 19, 2010 at 5:57 am
MANU-J. (2/19/2010)
His question was regarding difference in service pack level as he got confused with OS pack level and SQL SP Level.
Oh! I see, thank you MJ.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply