sql server 2000 and sql server 2000 64 bit

Question

Post reply

sql server 2000 and sql server 2000 64 bit

Pavas Malviya

Ten Centuries

Points: 1109
More actions
April 25, 2005 at 5:36 am

#102497

What is the difference between sql server 2000 and sql server 2000 64 bit.
How can i find out which one i am using?
Kindest Regards,
Pavas
Dream The Dream
Explore the World
Experince The Exhilaration

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Kishore-132325 Hall of Fame Points: 3784 More actions · Answer 1

You can run select @@version in your QA. This will tell you what version of SQL server are you using.

--Kishore

Pavas Malviya Ten Centuries Points: 1109 More actions · Answer 2

@@version

command is not running !This is giving me following error!

Server: Msg 1044, Level 15, State 1, Line 1

Cannot use an existing function name to specify a stored procedure name.

Kindest Regards,

Pavas

Dream The Dream
Explore the World
Experince The Exhilaration

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 3

What did you execute? Open a new window in Query Analyzer and execute the line below (and only that line):

SELECT @@VERSION

Anyway, if you do not know which one you are using you are probably not using the 64-bit version. And in any case, there is nothing in general that you should be concerned about if you are running 64-bit. Or do you have something specific in mind?

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

Pavas Malviya Ten Centuries Points: 1109 More actions · Answer 4

Nothing specific

when i run this commend it give me below detials.

which version is it?

Kindest Regards,

Pavas

Dream The Dream
Explore the World
Experince The Exhilaration

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 5

Uhm, you are running SQL Server 7 SP4.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

Glenn Wallis SSC Eights! Points: 811 More actions · Answer 6

FYI

Here is the string returned on a 64bit Itanium:

Pavas Malviya Ten Centuries Points: 1109 More actions · Answer 7

Does this mean i am using sql server 7

Kindest Regards,

Pavas

Dream The Dream
Explore the World
Experince The Exhilaration

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 8

Yes, like I said, SQL Server 7 with Service Pack 4.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

philcart SSC-Forever Points: 47794 More actions · Answer 9

Also FYI, heres SQL Server 2005 x64

Microsoft SQL Server 2005 - 9.00.1116 (X64)

Apr 9 2005 20:59:14

Beta Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)

Looks like they need to update their copyright

--------------------
Colt 45 - the original point and click interface