I have some performance questions.
First Off: Windows 2003 (all updates), SQL 2000 (sp3) , 2 Xeon 3.2GHz
processors (w/ ht enabled), 4 120GB U320 drives configured in raid 5, 2GB
ram, GB NIC, TCP/IP only protocol on network.

In the event viewer:  In Application Log properties, there are options on
what to do "When maximum log size is reached."  I set it to "Overwrite as
Needed", but the next day it is changed to "Overwrite Events Older than 5
Days."

Does SQL Server 2000 Std Ed require processor licensing to access dual
processors on a Windows 2003 server? Will Server+User CALs licensing allow
access to both processors? This doesn't seem clear in Microsoft's licensing
documents and web pages.

Hello, I got an error while install SQL Server 2005 (CTP September)
The SCC(System Configuration Check) success, except 1 fails
- SQL Server Edition Operating System Compatibility - warning
as following messages:

Is there any way to install SP4, and keep the existing configuration.
Regards
Gopi

I was wondering if anyone has any book(s) recommendations.  What to *get*, what
to *stay away from*.  I'm just getting started with 2k, haven't really tried
looking for 2k5.
Thanks in advance,

1. is there any way i can totally switch off transactions in sql server so
that even if there are several statements with in a begin and commit\rollback
transaction , without waiting for either the commit or rollback , it just
commits all the changes.

I have a pretty big Access Database with all the tables in Access.  We
recently have the need to move our tables into SQL.
I created a Test Database in Access.  I have linked the Database to the
SQL tables.  However, when I try to do some of the everyday tasks in the

I'm trying to install SQL Server 2000 on my Win XP with SP2 box, but I get
an error.
Error message: "Microsoft SQL Server 2000 Enterprise Edition server
component is not supported on this operating system. Only CLient

Dear folks,
I've got an issue with an Sql installation and I can't work out. Currently,
on my laptop there is XP Home running without problems. I'd need to have
there a sql server. Well.

i am currently working on SQLSERVER 2000 version.
1) Like in Oracle we have NVARCHAR dataype to support internationalization
what is the simillar one in SQLSERVER 2000
2) Oracle supports unique time zones for each database instance, even for

I wrote a simple demo script to create and populate a SQL Server database.
However,  I need to test whether the database already exists and,  if so,
whether the user want to permit its deletion and recreation.  I want to
create and OK/Cancel msgbox from within the script.

can we run SQL Server 2000 and SQL Server 2005 on the same machine?

We currently have a production box running Windows NT server with SQL 7.0.  
We also have the migration box running Server 2003 Std. and SQL 2000.  How
can we migrate the data from the old server to the new server, making sure we
keep all information like usernames, passwords, etc ...

In a single server I have created 3 databases.
One in for US customer
One in for UK customer
One in for CANADA customer