I've been asked to write a script to modify all smalldatetime fields to
datetime.  I can easily generate the alter statments in qa with some sql, but
the issue is that there are problems when trying to run the alter statements.
Default constraints on the smalldatetime fields get ...

       According to the requirement I need to install the database files on
U:\ and T:\ which are mapped network drives. It is giving me the error
"Device activation error. The physical file name
'T:\MSSQL$SQL01\data\product.mdf' may be incorrect."

Can you run SQL 2000 on a server (2003) running Exchange 2003? The server
has 3GB of memory and only handles 50 mailboxes (dull xeon cpu's, RAID 5),
using 1GB at this time.
Dave

Hi all, I have a box running sql2k on win2k3. Can I install sql2005 beta2 on
the same box and both the versions run side by side? Are there any known
issues?
thanks

I am trying to burn an ISO image of my SQL2000 server CD for backup in the
event of loss of the CD. I am having a lot of trouble with the files in the
PTS directory, specifically PTSFULL.EXE and PTSLITE.EXE. I can't copy them
either with Nero or manually to a folder.

I have a question about the Sql Server Memory Usage in my server.
I have a server with:
win2000 sp4,sql server 2000 sp3a,RAM = 6143MB,WIN VIRTUAL MEMORY =
2046MB,sql Server Memory configuration: (Dinamically) Min = 0MB MAX=4096MB

Hi I am attempting to install SQL Server 2005 and am having problems
installing the Management Studio. I keep getting an error alluding to the
fact that it can't find a disk???
Attached is the log file.

Can somebody please help me changing master logfile location?
I have followed the steps changing startup parameters and moving log file to
new location but SQL service will not start.

Maybe the wrong group, if so then sorry in advanced.
First question:
I have SQL 2000 SP3a installed on a W2K3 server with 4 gigs of mem.  I want SQL to use 3 gigs of memory, so I adjusted the memory management in SQL to use 3 gigs.  I set /3GB in the boot.ini, but when I look at ...

We are considering getting a LeftHand network storage solution to house ous SQL
databases.  We are intererested to see if anyone is using SATA for SQL, and
if the performance is acceptable.
Any information would be appreciated.

i am running into an issue, hoping someone can point me in the right direction.
i have a active/passive sql server cluster
when it was built we gave it 24 gigs of san storage, but now we the db is
growing we need more space.  i had thought that i could just add more as i

Does the following KB article also apply to SQL Server 2000 Enterprise
Edition SP3 on Windows 2003 Ent Ed sp1:
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071

I have a SqlServer2000 on a windows2000 server machine. I need to change the
IP server address (only the IP. not the server name).
I know that clients that will try to connect using ip address will need to
change it, BUT, the sql server needs anything else respect to the

What is the best way to install SQL Server 2000 ?
On Windows Server 2003 ?
On Windows Server 2000 ?
On Windows XP ?

In my log file I have the message "SQL server listening on x.x.x.x: 1433" the
ip address is not a part of our network. I don't see this address listed in
the network configuration utility. I get a timeout when I try to ping the
mysterious address.