I have SQL Server 7.0 installed in a Fail-over cluster and currently, Full-text indexing is not installed, since our full-text index resides on a different physical server. In an attempt to consolidate our servers I am looking at installing full-text indexing on our cluster. I understand that there will probably be issues getting the Full-text indexing service to fail-over, but I'm not too concerned with that.
What I am concerned with, is, will I need to re-install the latest SQL Server 7.0 service pack? Does anyone know of any security holes with an un-patched version of the full-text indexing service?
Any advice on this situation is greatly appreciated. Thanks!