We are upgrading our 2000 SQL server running Server 2003 Enterprise (x86)
from 4 procs to 8.  The server is currently configured with 8Gigs of RAM.  Is
this enough?  What is the recommended amount?  I am concerned that too little
memory will starve the CPU's.

   After I upgraded the existed SQL SERVER2000 to SQL SERVER 2005. But I
saw the SQL SERVER is still running V8.0(It means the SQL SERVER is still
running the 2000 core).
   But I remembered that I had selected the options to upgraded the existed

I have a strange problem here: I'm trying to install sql server 2000 on my
windows xp professional... I already installed it before (couple of months),
but it was evaluation copy (and it expired, so I uninstalled it). Now, I'm
trying to install developers edition sql server 2000, ...

Hi;
Some of our customers will need to install SqlServerExpress. By definition
these will be non-technical users. What is the best url to point them to to
both install it and to tell them how to install it.

I have already installed SQL Server 2005 Standard Edition on my development
machine.
Now I have to develop an application to distribute database with it and want
database ebeded and require to install SQL Server 2005 Express.

I have a client who is running a SQL 2000 database. I need them to back a
backup copy for me so that I can restore it to my SQL 2005 database for data
import. What is the simplest method of the following:
1. Create SQL Server 2000 backup (while system is in use.)?

Is it possible to install SQL Server 2005 Standard as an upgrade to MSDE
such that it then becomes the default instance replacing MSDE as the
default. I have read articles describing an upgrade to SQL 2005 Express, but
not Standard. The articles indicate that existing databases ...

I learn that 'Community Technology Preview (CTP) version of SQL Server 2005
Express Edition Service Pack 2' is at the Microsoft download site.
What is the 'Community Technology Preview (CTP)' version of SQL Server 2005
Express Edition?

I have an existing SQL 2000 database that I would like to split into
multiple file groups.  I know how to add a file group but how would I move a
table to a secondary and third file group and also how would I move indexes
to a different file group?

We have SQL server 2000 Enterprise on Windows 2003 Enterprise.
We've upgraded RAM from 2GB to 4GB and we set SQL server to dynamically
allocate all available memory. Do we still need to change anything else, do
we need to add /3GB swith to boot.ini file?

After installing SP4 on server, I checked ProductLevel and Productversion and
they still showed RTM and 8.00.194.
I did see a whitepaper about this regarding SP1 and the fix was to apply the
latest SP which is SP4, so this does not apply to me.

I don't understand why.
My SQL Server 2005 is called PC\SQLEXPRESS. I use PC\Robert (administrator)
account on Windows XP Professional. I use Windows Authentication. Remote
connections are switched on ("Using both TCP/IP and names pipes.")

Hi we have MSSQL installed as part of our SBS2003 server installation.  This
has been installed to the default location on our C: drive.  It is used
currently as the database for our back up software, but will soon be used to
archive all of our emails

I have installed SQL Express multiple times and searched the Internet for
hours without finding a solution that works.I downloaded SQL Express from
http://msdn.microsoft.com/vstudio/express/sql/download/  (SQLEXPR_ADV.EXE).  
These software installations are on a single computer ...

Is there a way one can tell whether a certain set of binaries is for
enterprise or standard edition and whether it is for 32 bit or 64 bit?
Thanks much.
Sajal.