version difference SQL server 2000

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » version difference SQL server 2000

version difference SQL server 2000

Rate Topic

Display Mode

Topic Options

Author

Message

bmr270

Posted Thursday, September 18, 2008 11:42 AM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 3:30 PM
Points: 79, Visits: 354

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

David Benoit

Posted Thursday, September 18, 2008 11:47 AM

SSCrazy

Group: General Forum Members
Last Login: Saturday, May 18, 2013 8:26 AM
Points: 2,063, Visits: 3,440

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

bmr270

Posted Thursday, September 18, 2008 12:09 PM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 3:30 PM
Points: 79, Visits: 354

Yes, We have one instance.

Post #572035

RBarryYoung

Posted Thursday, September 18, 2008 12:16 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

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

bmr270

Posted Thursday, September 18, 2008 12:30 PM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 3:30 PM
Points: 79, Visits: 354

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

RBarryYoung

Posted Thursday, September 18, 2008 1:38 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

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

Steve Jones - SSC Editor

Posted Thursday, September 18, 2008 1:50 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 2:54 PM
Points: 31,410, Visits: 13,726

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

Jeffrey Williams 3188

Posted Thursday, September 18, 2008 4:07 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, May 17, 2013 11:21 AM
Points: 4,317, Visits: 9,216

bmr270 (9/18/2008)

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

bmr270

Posted Friday, September 19, 2008 9:23 AM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 3:30 PM
Points: 79, Visits: 354

Thanks,

Yes that is windows service pack 2

Thanks to all for your reply

Post #572649

« Prev Topic | Next Topic »

Permissions