SQL Server 2000 and 64Bit Operating System

Hot Topic

increasing maximum of tables to greater than 256 ?
Return more than 4000 characters from CLR stored procedure
sql express
Conversation ID cannot be associated with an active conversation
making the shift from Access SQL to 'Real' SQL ;-)
DataDir Property - Is it possible to store files on more than 1 drive?
Management Studio lists all databases
Converting a type into another one
Bug in OWC11 - Wrong Totals
How to move an OLAP cube to another SQL Server 2005?

SQL Server

Allowing Remote Connections
June CTP Won't Install
Expand/Collapse all buttons in reports
Problems with remote SQL 2005 server and excel as an input source
Reporting Server Project 2005 - xml datasource - Querying the data
SQL Express won't work in iis but works fine inside vs2005
How to add SQL Server 2005 Stored Procedures to Visual SourceSafe by using Visual Studio 2005?
Strange cube processing error
Best way to inform .NET app of change in DB content
Report/Query Parameters

SQL Server 2000 and 64Bit Operating System

We are in the process of upgrading many of our servers to HP Blades. We currently run SQL Server 2000 on an old Compaq with Windows 2000 Server as the OS. Our new blades have 64bit Processors. We want to go ahead and take advantage of the additional processing power of the new servers but cannot migrate to SQL 2005 at this time. Can we run SQL Server 2000 Standard Edition on a 64bit OS or do I need to fall back to running the 32bit Windows 2003 on the new server until we can perform a full migration If anyone can give me a rundown on our options, I would greatly appreciate it.

Thank You

Answer this question

SQL Server 2000 and 64Bit Operating System

  • bistok

    The "preferred" solution given your constraints would be to use the 64 bit version of SQL Server 2000. This only runs on IA64 machines, however.
  • SQL Server 2000 and 64Bit Operating System
Answer this question