Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
SQL SERVER EditionHello Everybody, I have SQL SERVER Enterprise Edison install on our server...How can i know whether is it 32 bit or 64 bit ? which is the most common version (32 bit or 64 bit ) client use now a days ?
Post Follow-up to this message
RE: SQL SERVER EditionHi select @@version will return "(Intel X86)" as part of the string for 32 Bit. There are still more 32bit installs than 64bit Itanium installs. Regards -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Zurich, Switzerland MVP Program: http://www.microsoft.com/mvp Blog: http://www.msmvps.com/epprecht/ "mvp" wrote: > Hello Everybody, > I have SQL SERVER Enterprise Edison install on our server...How can i know > whether is it 32 bit or 64 bit ? which is the most common version (32 bit or > 64 bit ) client use now a days ?
Post Follow-up to this message RE: SQL SERVER EditionI ran that and i got Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: ) still it doesn't say any where whether is it 32 bit or 64 bit ? thx "Mike Epprecht (SQL MVP)" wrote: > Hi > > select @@version will return "(Intel X86)" as part of the string for 32 Bi t. > > There are still more 32bit installs than 64bit Itanium installs. > > Regards > -------------------------------- > Mike Epprecht, Microsoft SQL Server MVP > Zurich, Switzerland > > MVP Program: http://www.microsoft.com/mvp > > Blog: http://www.msmvps.com/epprecht/ > > > > "mvp" wrote: >
Post Follow-up to this message RE: SQL SERVER EditionHi For SQL Server 2000, "Intel X86" implies 32bit version. Regards -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Zurich, Switzerland MVP Program: http://www.microsoft.com/mvp Blog: http://www.msmvps.com/epprecht/ "mvp" wrote: > I ran that and i got > > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 > Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windo ws > NT 5.2 (Build 3790: ) > > > still it doesn't say any where whether is it 32 bit or 64 bit ? > > thx > > "Mike Epprecht (SQL MVP)" wrote: >
Post Follow-up to this message RE: SQL SERVER EditionOh Ok. Thanks for the quick replies. Just want to know, i have Windows 2003 SERVER O/S install on my server, can i install 64 bit version of sql server ? What are the procs and cons of windows 64 bit versions ? thx "Mike Epprecht (SQL MVP)" wrote: > Hi > > For SQL Server 2000, "Intel X86" implies 32bit version. > > Regards > -------------------------------- > Mike Epprecht, Microsoft SQL Server MVP > Zurich, Switzerland > > MVP Program: http://www.microsoft.com/mvp > > Blog: http://www.msmvps.com/epprecht/ > > > > "mvp" wrote: >
Post Follow-up to this message Re: SQL SERVER EditionSQL Server 2000 64 Bit only runs on an Itanium. SQL Server 2005 64 Bit only runs on an Itanium and there is a separate build for X64/EM64T processors. There have been a few discussions on this in these newsgroups. Have a Google for them. Regards -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Zurich, Switzerland IM: mike@epprecht.net MVP Program: http://www.microsoft.com/mvp Blog: http://www.msmvps.com/epprecht/ "mvp" <mvp@discussions.microsoft.com> wrote in message news:31095334-0BD7-4584-9934- 877BFA59B7A9@microso ft.com... > Oh Ok. > Thanks for the quick replies. > Just want to know, i have Windows 2003 SERVER O/S install on my server, > can > i install 64 bit version of sql server ? What are the procs and cons of > windows 64 bit versions ? > > > thx > > "Mike Epprecht (SQL MVP)" wrote: >
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
