I'm having a noise word problem that I don't seem to see in any of the other
postings.
Here is the setup:
SQL Server 2000 Standard Edition SP3 running on Win 2003 Server.

My app (VB.NET, .NET Framework 1.1) intalls database tables for a
database.  Then it is supposed to create full-text catalogs.  It works
well on my machine but not on another machine.
here is error message I get:

We implement the wild card search using 'Contains' in full Text Search.
However the search with the word portion within the word could not be
achieved
In otherwords if I seach with the key word 'plan' the test result should

I use full text search using containstable for search on my intranet
site.  Its been working wonderfully.  However, I have recently been
working on an upgrade to my search page to allow users to exclude
words.  When excluding words I use the "and not" operator.  I have

I'm currently writing a search system in ASP with Javascript connected in to
SQL to search a product database. I'm using the FreeTextTable command to
search a number of fields and bring back results in rank order which is
working fine. However when the user submits a word in the ...

I have a table with the fileds  empid,empname,designation,branch.. etc I
have 5 types of  designations CEO,BM,PL,Tester,and PRG and the two branches
those are Hyderabad and Visakhapatnam i need the query like
first CEO name next Hyderabad BM Name next Hyderabad PL name next ...

When using Microsoft Index Server file system catalogs, the Index Server
generates 'abstracts' which give the user an 'at a glance' indication of the
entry contents.  Does Full-Text Indexing within SQL Server provide such
abstracts?

running SQL2000 SP3 (8.00.818)
first
1) when we upgraded our hardware, ie,rebuilt SQL on a new machine, we
noticed several system stored procedures were missing, including,

I have a problem whith knowing what is inside catalog, especially words that
are indexed in tables. I want to improve some search capabilities, and I need
to know structure of index (catalog). My improvements will probably be
approximate string matching, by word distance, and I ...

I have a CONTAINS search on a full-text index and I'm having trouble running
it on multiple terms without using an operator like AND or OR.
Here is my search query:
SELECT  id

No BUILTIN\ADMINISTRATORS has not been removed or altered :>
We aquired a new box to replace an existing server that was out of warranty.
Working with the developers we have gradually moved all the databases from
the old box to the new box and everything was working fine.

We are developing a Content Management System using both SQL Server
2000 and file system as repository.
The files (content) are stored on disk and addition properties are
stored in an SQL Server database.

I am writing some code in VB.NET and need to pass an SQLServer object
to a method.  How do I do that?  What is the type of SQLServer object?
I created it using :
Dim oSQLServer = CreateObject("SQLDMO.SQLServer")

I am getting the same number of records resulting from this search,
regardless of the use of the operators "AND" and "OR"
All three of these yield the same results:
declare @keywords varchar(25)

1>    how to select 3rd maximim salary from employee table
    which contains empid,name,salary.
2>   how to select duplicates from a table which doesnt have primary key