CSA full-text search

juergen.bauer · ‎07-26-2007

Hi Netpros,

when searching through the event log in CSA MC 5.2 we get the message that sql full text search is not installed.

Did not find any info on how to do this other than under "maintenance - database maintenance - full-text search":

---

SQL Server FullText Search service installed: No

SQL Server FullText Search service started: No

Full-text indexing enabled for database csamc52: No

Event table full-text indexing enabled: No

Auto-update of event full-text index enabled: No

Summary:

Full-text indexing enabled: No

Recommendations:

- install SQL Server FullText Search service (Microsoft SQL Server 2005 Express Edition with Advanced Services or above needed).

---

How do i install the advanced services? Is it possible? Is it worth it? - I mean so far I found anything I was searching for?!

Thanks

Juergen

tsteger1 · ‎07-26-2007

Hi Juergen,

I did not see an option to install the full text search when I did a manual install of SQL Express 2005 (but it says it's supported).

I just installed a new MC with SQL Server 2005 full version and fulltext search but haven't had a chance to see what difference it makes.

There is some info in the help file about what it can do.

Tom