Installing SQLServer EE for full text searching

Hi there,
Does anyone know how I go about upgrading from SQL2000 standard edition to
SQL2000 enterprise edition (I need to install full-text searching). Is it as
easy as slamming in the enterprise edition CD and upgrading, or are there any
known issues?
Thanks
Cammie.
It is as easy as that. You should install SQL 2000 standard before adding
SQL 2000 Enterprise.
Hilary
"Cammie" <Cammie@.discussions.microsoft.com> wrote in message
news:7ED562E7-97C4-447C-ADB6-23782072E195@.microsoft.com...
> Hi there,
> Does anyone know how I go about upgrading from SQL2000 standard edition to
> SQL2000 enterprise edition (I need to install full-text searching). Is it
> as
> easy as slamming in the enterprise edition CD and upgrading, or are there
> any
> known issues?
> Thanks
> Cammie.
|||Cammie,
You can upgrade from Standard Edition to Enterprise Edition (see SQL 2000
BOL titles "Upgrading an Existing Installation of SQL Server" and "Editions
of SQL Server 2000" for details), but you don't need to install the
Enterprise Edition just to get Full-Text Search (FTS) as FTS is installed by
default with the Standard Edition.
If you have a need for both Editions, you can install Standard as the
default installation and Enterprise Edition as a named instance and both
will have FTS capabilities as long as you install both on Win2K/Win2003 OS
Advance or Enterprise server editions.
Regards,
John
"Cammie" <Cammie@.discussions.microsoft.com> wrote in message
news:7ED562E7-97C4-447C-ADB6-23782072E195@.microsoft.com...
> Hi there,
> Does anyone know how I go about upgrading from SQL2000 standard edition to
> SQL2000 enterprise edition (I need to install full-text searching). Is it
as
> easy as slamming in the enterprise edition CD and upgrading, or are there
any
> known issues?
> Thanks
> Cammie.

integer count

Im not at all familiar with sql programming text but i need to do something I cant find an example of. Im using the sql query inside of an access 2003 database. Basicall I have two tables. One that hold all the employees personal informaton AS WELL AS Total Days Worked AND TotalPoints.

A day worked is represented by a "w" form within my vb program.
I used to sql code:
SELECT COUNT(*) AS TotalDW
FROM TblEmpAttendance
WHERE Value="w" And TblEmployee.EmployeeID=TblEmpAttendance.EmployeeID ;

To get the "w" total or count in this case.

--This seems to work without a problem please let me know if you see a problem with it.

--Now on to my bigger problem.

The second table has 3 fields-- EmployeeID, Date,Value
The date comes from my vb program(a calendar with textfields to hold values)

However-- to limit the code I use in my vb program I wanted to take a point total for all points from the 2nd tbl

In vb I can use --IF Isnumeric --But I have no clue how to do it woth SQL code!!

A Point Value can only be 1 of 4 values(a 1,2,3 or a 7)

But how do I rewrite the below code(if below code is even close!) to count all of the numeric values for the field "Value" when not every entry for "Value is a numeric entry?

SELECT COUNT(*) AS TotalPoints
FROM TblEmpAttendance
WHERE Value= '1 or 2 or 3 or 7' And TblEmployee.EmployeeID=TblEmpAttendance.EmployeeID ;

Hopefully I explained sufficiently..Thanks In advance!Did you try:

SELECT COUNT(*) AS TotalPoints
FROM TblEmpAttendance
WHERE Value IN ('1', '2', '3', '7')
And TblEmployee.EmployeeID=TblEmpAttendance.EmployeeID ;
;)|||Nope but I will now..Thanks Much! it is highly appreciated..Just tried it...I only have 4 sample employees to check it with but it seems to work...
Many thanks!!!