Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

version difference SQL server 2000 Expand / Collapse
Author
Message
Posted Thursday, September 18, 2008 11:42 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, November 10, 2014 8:12 AM
Points: 85, Visits: 382
When I check the version of SQL server in Enterprise Manager

It is showing Product 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
Post #572008
Posted Thursday, September 18, 2008 11:47 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:07 PM
Points: 2,049, Visits: 3,592
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
SQL Tentmaker
“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Post #572012
Posted Thursday, September 18, 2008 12:09 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, November 10, 2014 8:12 AM
Points: 85, Visits: 382
Yes, We have one instance.
Post #572035
Posted Thursday, September 18, 2008 12:16 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 1:19 PM
Points: 9,294, Visits: 9,491
Tell us what you are doing in each case to check the version.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #572040
Posted Thursday, September 18, 2008 12:30 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, November 10, 2014 8:12 AM
Points: 85, Visits: 382
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?
Post #572057
Posted Thursday, September 18, 2008 1:38 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 1:19 PM
Points: 9,294, Visits: 9,491
Still waiting for an answer to my question.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #572116
Posted Thursday, September 18, 2008 1:50 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:03 PM
Points: 31,276, Visits: 15,728
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.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #572126
Posted Thursday, September 18, 2008 4:07 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 12:19 PM
Points: 4,360, Visits: 9,543
bmr270 (9/18/2008)
When I check the version of SQL server in Enterprise Manager

It is showing Product 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
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #572186
Posted Friday, September 19, 2008 9:23 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, November 10, 2014 8:12 AM
Points: 85, Visits: 382
Thanks,

Yes that is windows service pack 2

Thanks to all for your reply
Post #572649
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse