Hi, I need to know what is the difference between sql
server 2000 32bits and sql server 2000 64bits.

Do any one know the differences??

Thanks.

They have different hardware (processor) requirements.

.... and 65 bit bas use flat addressing of up to 128GB (I think) memory, where 32 bit can only do
flat addressing of 3 GB or paged addressing of up to 64 GB.

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver


".." <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thanks for your comments.

Do you know how i can identify which version do i am using
if 32bits or 64bits??

Thanks.

SELECT SERVERPROPERTY('edition')

might do it


--
HTH
Ryan Waight, MCDBA, MCSE

"maria" <anonymous (AT) discussions (DOT) microsoft.com> wrote