Ok, heres my question.
We have a custom application that runs off a SQL 2000 Database.
What hardware would you recommend for it.
The database is 14 gigs, and is accessed by about 100 users, usually a max

After deleting all the SQL server instances on my Win2000 server, now the
installation of the default instance (the first instance) of  SQL Server
2000 aborts with a "[Microsoft][ODBC SQL Server Driver][Shared
Memory]ConnectionOpen (SECDoClientHandshake())" error, as per the latter

I have 3 seperate SQL 2000 Servers that are running one database each. As
part of my disaster recovery plan I would like to install SQL server 2000 on
one new server and then install the 3 databases on this one server which will
server as a secondary server and simply ship the ...

I'm trying to to troubleshoot why the two counters for Procedure Plans &
Execution Contexts are low (they stay at 50%).  because these two counters
are low they cause the cache hit ratio to stay at 50%.  All other cache
ratios are close to 100%.  This includes the buffer cache ...

SQL writes faster to a Raid 5 or Raid 1?  It reads faster from a Raid 1
correct?

I have a question:
Is it possible for SQL Server 2000 Ent. Ed. to use more than 2gb of RAM
(my server has 4gb available) on a server with the Windows 2000 Server OS.
Or do I need Advanced Server at least ?

I have a dell server with 4G of memory and 4 1.6G CPUs, hosting one
application db. SQL Server 2000 version was installed on the server, OS
Windows 200. Right now it can only utilize 2 G of Memory.  I am in the
process of doing server consolidation and planning to move one ...

I installed sql 7.0 on a different workstation of mine.  I am getting a log
in error of 1069.  I am using administrator as the sqlagent id.  
Administrator on this computer does not have a passwork.  I created a
password for the server but still keep getting this error.

I am running sql 2000. I am setting up maintenance jobs to backup databases
and transition logs for a certain amount of days. The database logs are
backing up fine and purging the old backup files. However the transition logs
are backing up but not purging the old files. Any ...

Does SQL Server 64 Bit support linked servers, I am trying to read data from
a 32 bit server, it tells me the ODBC driver is missing. The driver is
installed in the drivers section in ODBC.
Any ideas ?

   I have been trying to find out what optimization method SQL Server 2000
uses. Of the little that I have found on the subject, indicates that SQL 2000
uses Cost Based, however, I was told by our consultant that this is incorrect
and it is really or should really be rules based ...

Good Morning,
I have a new install of SQL 2000 running on 2003 server.  I have just
installed sp3a.  Is it now fully patched or are there other patches that need
to be installed?  If so which ones?

How I can see SQL Server service pack installed in my
server?
Thank to all
Pippo

On a two node active/passive cluster, if one node has version 818 of the
binaries and the other node has 194 version of the binaries, can we runt he
sp3a set up from the node with 194 version of the binaries to update it to
sp3a and then apply the security patch? Or will the sp3a ...

BOL has the following statement in the section Preparing to Install SQL
Server 2000:
Log on to the operating system under a user account that has local
administrative permissions, or assign the appropriate permissions to the