September 18, 2008 at 11:42 am
When I check the version of SQL server in Enterprise Manager
It is showingProduct version:8.00.2039(SP4)
When I check the version of SQL server in Query analyzer (@@version)
It is showing Microsoft SQL Server 2000 - 8.00.2039 (Build 3790: Service Pack 2)
Thanks,
Bmr
September 18, 2008 at 11:47 am
It is SP4 according to the version database so, the question has to be are you pointing to the correct instance in Query Analyzer?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 18, 2008 at 12:09 pm
Yes, We have one instance.
September 18, 2008 at 12:16 pm
Tell us what you are doing in each case to check the version.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 18, 2008 at 12:30 pm
we recently applied sp4. It has to show the same version in QA and EM.
I want to know that, will it create any problem in future?
September 18, 2008 at 1:38 pm
Still waiting for an answer to my question.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 18, 2008 at 1:50 pm
I wrote about this some time ago for SQL 2000. Basically the file extended properties and the version in master could conceivably be different. I'd check both and that might tell you where each tool reads the value from. Might not be the same place.
September 18, 2008 at 4:07 pm
bmr270 (9/18/2008)
When I check the version of SQL server in Enterprise ManagerIt is showingProduct version:8.00.2039(SP4)
When I check the version of SQL server in Query analyzer (@@version)
It is showing Microsoft SQL Server 2000 - 8.00.2039 (Build 3790: Service Pack 2)
Thanks,
Bmr
If I am not mistaken - the versions are the same. SQL Server version 8.00.2039 for both QA and EM.
The build information is for the OS - Windows NT 5.2 Service Pack 2.
You can also run the following:
Select serverproperty('ProductVersion')
,serverproperty('ProductLevel');
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 19, 2008 at 9:23 am
Thanks,
Yes that is windows service pack 2
Thanks to all for your reply
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply