March 2, 2004 at 6:08 am
Hello,
I got a request to enable full text indexing for a particular Database on one of our SQL Server 7.0 Instances.
From what I have read, I would have to re-run SQL Server setup program using custom install to enable this ?
It seems dangersous to me. If I deselect everything in the custom install 'except' full text indexing will it only add that component or will it also de-install all the unchecked components? Also, If I do add it by rerunning the install, I'm not sure what other steps I would have to take.
any help/feedback would be appreciated.
March 2, 2004 at 3:58 pm
You are safe, In spite of your best efforts to make a mess SQL 7.0 will not let you harm existing installed components. You will need to exercise your Backup / Recovery Plan (just in case) define a service outage window and install the components (FULL TEXT INDEXING) from your CD by re-running the installation program. No you will not remove existing components and the dialog box is very specific as to what will be added. Please Reference your Books on line for specifics on Creating and populating your catalogs and the like. Now I hope your developers are not asking for the install just to use the "CONTAINS” predicate.
As per books on line:
A full-text index must be defined on a base table; it cannot be defined on a view, system table, or temporary table. A full-text index definition includes:
The full-text index is populated with the key values. The entry for each key has information about the significant words (noise-words or stop-words are stripped out) that are associated with the key, the column they are in, and their location in the column.
T-SQL has two new predicates for testing rows against a full-text search condition:
Tr-SQL has two new functions that returns the set of rows that match a full-text search condition:
sp_fulltext_catalog administers a full-text catalog.
sp_fulltext_column administers a full-text indexed column.
sp_fulltext_database initializes or disables full-text indexing.
sp_fulltext_service changes full-text service settings.
sp_fulltext_table administers a full-text indexed table.
Good Luck!
Jim Babington
Jbabington
Jbabington@hotmail.com
March 2, 2004 at 4:14 pm
Thank you very much! I have never had to 'rerun' a SQL Server install program and I wasn't sure what to expect.
Sometimes with Microsft installs, it will uninstall enchecked components. Since I don't have a sandboc to play in.. i wanted to make sure.
Thanks again.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply