Full Text Index Export to Test Server 1

[gus121]

Hi we have Full Text Search set up on our web server which works fine.

I am setting up a test enviroment locally and i cannot get the full text index to function.

I have imported a copy of the database. In Enterprise Manager under full text Catalogs it still lists the old Full text catalog with the old full text catalog path (which does not exist on the test machine).

When i go to delete the existing Full Text Index catalog i get an error message. If i try to repopulate the index i also get an error message. If i try and create a new index or edit existing index i get an error message

I tried disabling the full text search by using.

Exec sp_fulltext_database @action = 'disable'

which appered to work ok but when i tryed to enable it again
i got an error meassage that the path of full index does not exist.

Now even thought Full text indexing is disable it still lists the catalog in enterprise manager and i still cant remove it edit it etc....

Any ideas welcome

-Gus

 

[mrdenny]

The easiest way is to create the folders that are on the production system then you can repopulate the index.

You can also update the sysfulltextcatalogs table, path column to a valid path. After you update this you should be able to repopulate the index.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[gus121]

Hi mrdenny thanks for your help.

When i go into edit the path in the sysfulltextcatalogs table i get a error message "Ad hoc updates to the system tables is not allowed a system administrator must allow the updates" or some thing allong those lines. How do i go about giving my self sufficient rights i have loged on to the machine as system administrator i think.

thanks

-Gus

 

[gus121]

Hi Mr denny,

ignore the last post.

I worked out how to do this:

right click server name
select properties
select Allow direct modification to the system tables in the server behavior.

thanks

-Gus