I'm having a problem with queries updating 'dates'. Its a SQL 2K on Win 2003.
The application is running querries using date in canadian format (ddmmyyyy)
and SQL errors out and works fine if the date is in US format (mmddyyyy).
I tried to change the language settings in the ...

Tipically when I create a new SQLSERVER 2000 instance I
put a new port number or the same port number of my
default istance? What's better method? Why?
I'm a vb developer and I need to create a good connection

I am planning to install SQL server on a new machine. The machine
configuration is 2x Intel XEON 2.4 Ghz. Now the confusion is that which
version of SQL server 2000 shall i go for? a 32 bit or a 64 bit version. Is
that a multiprocessor means 2* 32 ( 64 bit) parocessor ? I am really

Downloaded sqlserver eval. When I click to install, it reads contents then
stops and gives error message "not enough disk space - free up 439KB". I have
80 G of free space. Two G of memory. Tried on two different computers and got
the same error message.

I read an articale some time ago that stated that the
BUILTIN\Adminisrator account should be modified so that
the Admins of the Windows OS do not have SA rights to the
Databases in SQL Server 2000.  I can't rememner the steps

I have some problem with using merge modules for MSDE 2000 in my application
MSI setup. This problem described in article "Using SQL Server 2000 Merge
Modules May Result in Confusing Message" (Article ID    : 274224) in Microsoft
knowledge base.

I will have some servers that might need to downgrade from Sql 2000 Standard
to SQL 2000 Workgroup and want to be prepared for the questions.  Assuming
that the hardware and software are in spec, has anyone done this yet?  Any
KB's or other MSFT notes on the topic?

I've read from an article, that recomended to setting SQL Server Use
processor number 1,2, and 3 (If the server use 4 processor).
Processor number 0 should not be used due to avoid the logon problem.
Does this information correct?

Basically, I have a master db backup from a prod server. The path of data
and log files and errorlog are on different drive letters (C, F, G...). I
only have drive C on my test machine. here is the error I got:
Could not open error log file: 'C:\program files\microsoft sql

I have a medium size SQL database that I just moved to a new server...
The database is about 60 gb and the server I had it on before had 75gb of
space for data...  I have recently moved it to a larger server (300+)gb
expandable to 2.4tb...

I am currently building a dell 2800 running sbs 2003, i have 6 x 72 gig
drives, dual xeon processors 3 g ram etc.I am looking for some
clarity/explanations as to benefits configuring raid 10 on this unit,
it will be running sql, exchange and Isa with approx 20 users so

how must i configure SQL Server Enterprise Edition so it uses up to 8 GB
ram on
windows 2000 advanced server?
We habe upgraded RAM from 4 GB to 8 GB but SQL Server still uses only 3

I have a server (w2k, sp4) on which I have installed SQL w2k, sp3a.
It has two physical drives, C: (6gb) and D: (9gb).  During the
install, I wanted to place the data files on the second drive.  (I
know the executables and the system files go on the system drive.)  I

If we use processor based license for SQL Server will that improve
performance compare to CAL based licensing?
Thanks.
Ram

I'm having troubles installing both SQL 2005 and VS.Net on the same box. I
put VS.net on the box so i can easily modify source files from wherever i am
if i need to.
It seems that SQL2005 needs .Net 2.0 Beta and VS.Net needs .net 2.0 Beta 2 -