Full Text Catalog search in SQL

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Full Text Catalog search in SQL

Author

Topic

jbahri
Starting Member

1 Post

Posted - 2002-08-07 : 03:35:01

Hi

I have created a full text catalog in Northwind database on Employees table. But when I am issuing a query, no result is coming.

My Queries are :
Query1 :

SELECT lastName, FirstName
FROM Employees
INNER JOIN
CONTAINSTABLE (Employees, Title, '("Sales")') TempTable
ON Employees.EmployeeId = TempTable.[KEY]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Query2:

SELECT lastName, FirstName
FROM Employees
WHERE CONTAINS (Title, 'Sales')

Can anybody help me in this? Why I am not able to get any data? This query is not even throwing any error.

Regards
~Jitender

My Mail-id is : jitender.bahri@india.techspan.com

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-08-07 : 06:13:56

Have you done a Full population ?
In the Full Text Catalog folder of EM for the Northwind database select your Catalog, Right click and view Properties - what do you have for Item Count,Catalog Size,Unique Key Count

You need to run a full population to populate the full text index before you can use it.

HTH
Jasper Smith

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources