2005: beginner: full-text setup

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello,

(Sorry for my English.)

I am learning MS SQL Server 2005. I would like to use full-text search.

I have installed:

SQL Server 2005 Express Edition Advanced Services (SQLEXPR_ADV.EXE)

SQL Server 2005 Express Edition Toolkit SP1 (SQLEXPR_TOOLKIT.EXE)

The problem is that although I executed:

exec sp_fulltext_database enable

I cannot use full-text search. When I tried to call

exec sp_fulltext_service 'load_os_resources', 1

exec sp_fulltext_service 'verify_signature', 0

I got a message:

Full-Text Search is not installed, or a full-text component cannot be
loaded.

I cannot create full-text indexes, catalogs.

Please help. What should I do to be able to use full-text search. I cannot
find solution in Internet.

/RAM/


.

Relevant Pages

  • Re: Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked
    ... I would still try to import the data into your SQL Server instance instead of running linked server queries as you are doing. ... I can query it with no problem and view tabs in Studio. ... EXEC master.dbo.sp_addlinkedserver ...
    (microsoft.public.sqlserver.programming)
  • Re: No more indexing on text
    ... Looking for a SQL Server replication book? ... DROP FULLTEXT CATALOG CmpArchivorCat ... exec sp_fulltext_catalog 'CmpArchivorCat', 'create' ... both text/plain and text/html in my file type column. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Running a DTS Job from a stored procedure
    ... We are running SQL Server 2000. ... -- Create a Pkg Object ... EXEC sp_DisplayOAErrorInfo @oPKG, @hr ...
    (microsoft.public.sqlserver.dts)
  • Re: Error 21776: After creating new login
    ... EXEC DATA0003.dbo.sp_addlogin 'test','pwd' ... > another SQL Server session is not visible to the SQL-DMO session. ... > Jasper Smith ... >> Users collection. ...
    (microsoft.public.sqlserver.security)
  • Re: Auto truncate a string to be inserted to SQL table
    ... EXEC p --Warning was not returned ... Tibor Karaszi, SQL Server MVP ... >> Tibor Karaszi, SQL Server MVP ... >>> message is given...i might need to just truncate the string without halting>>> the process... ...
    (microsoft.public.sqlserver.programming)