SQL server 2000

[Dakota]

Hello, does anyone know how to find out what version (32-bit or 64-bit) SQL server your running?
Thanks

[coopster]

Welcome to WebmasterWorld, Dakota.

Have you checked the MS Support site?

[support.microsoft.com...]
[support.microsoft.com...]
[support.microsoft.com...]

[syber]

SELECT
SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition')

If it is the 64-bit version you should receive back;
8.00.760 SP3 Enterprise Edition (64-bit)

Art

[Dakota]

Thanks cooper
Checked out all the links, ran the query but still no real answer. Best I can do is guess and hope it is 32 bit

Thanks again

[Dakota]

Thanks syber
This is what I got back
8.00.76 SP3 Developer Edition

[syber]

64-Bit only comes in the Enterprise Edition

[Dakota]

Thanks alot for all your help.