Hello.  Sorry if this is a basic question but I don't think I quite
understand the CAL for SQL Server 2005 licensing.  According to microsoft's
site:
http://www.microsoft.com/sql/howtobuy/default.mspx

I have a server running SQL 2000 as the default instance and SQL 2005
as a named instance.  All has been workin just fine until I installed
SP4 for SQL 2000 (used to have SP3).  Now the SQLBrowser service fails
and gives an error 1067.  I uninstalled 2005 and re-installed and I can

What features of SQL 2005 will I loose if I install SQL Server 2005 on
Windows 2000 Adv Server?  also will there be any problems running it?  Thanks
in advanced

We as company just purchased this type of license "see below" for a new
server... it is 1 server license thinking we were sticking with SQL 2000...
"Microsoft® SQL CAL 2005 English OPEN No Level User CAL"
We are still running on another older server SQL 2000... We were going to

I'm building a new SQL 2000 server.  I typically use HP DL380 machines with
split backplane.  SCSI controller one will have a pair of 72 GB drivesin RAID
1 (C:).  This will be used for the operating system.  SCSI controller two
will have 4 300 GB drives in a RAID 5.  Three of the ...

I lost the log file but I have a MDF file in sql 2005, the log file backup
is bad too so how to recoiver the data for a DMF only ?

I have setup database (2000 and planning to upgrade to 2005) in which i
enter data in the amharic (ethiopian) alphabet.
The problem i have is sort order.
I have tried to change the collation but cant find one that seems suitable

I have recently taken over at a company that is running SQL 2005 on a server
that has two disk in a Raid 1 configuration.  I am not that up to date on SQL
and would like to know if it is possible to add more disks to change it to a
raid 0 + 1 set up without corrupting the data ...

I need ur help.
I have data like this.
Table name            :                mytable.
------------------------------------------------------------

I have inherited a Database that has what appears to be an odd setup for its
T Log files.  The transaction log files consist of 4 files.  Two of these are
your typical .ldf files.  The other two are .ndf files.  It was my
understanding that .ndf files are secondary data files for ...

When creating new table fields the default size (length) of nvarchar
is set to 50. Using Management Studio, where do I change this, so that
it suggests another default than 50 ?
Regards /Snedker

I've removed all sql server programs using Add/Remove Programs.   However; I
still see several sql services running in Services.   I also can't remove
manually the Microsoft Sql Server folder in Program Files even though I have
all the sql services disabled.

I have a Windows 2003 Server with two local disk drives one (C:) of 136 G
the other (D:) 409 GB. The Server (Dell) runs with 8 Intel Xeon 2.8 G Htz and
has 8 G of RAM. I have SQL Server 2000 installed and two databases total
combined size of around 50 G the data files are located ...

when i transfered my data(uploaded our server) then i find an error
run time error 2147467259(80004005) cannot gererated sspi contex
pls solve this .i shall be thank full to you
with regards

I want to Move SQL Server 2005 from one computer to another. Not
databases but the whole SQL Server Engine. What are the steps for me to
do so? I found a bunch of articles on the web
http://vyaskn.tripod.com/moving_sql_server.htm