Discussion Locked
0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am working on a project for a client in the construction industry, and have a small problem. I need to know if, using SQL Server 7, I can implement index server to do full text indexing on a field in the database containing microsoft word or excel documents. No one seems to know the answer, and I have had one or two people say that it can be done, but no one knows how to do it. Please help, our client is getting antsy!
3 replies
To do indexing within the Server you can use the 'Full-Text Indexing Wizard' if the data is stored as text, otherwise you can use the Index Server for external files by adding a lonked server and using the OLE DB provider, I suggest that you look atthe following papers;
Microsoft Servers - Full Text Search -
http://www.microsoft.com/SQL/productinfo/fulltext.htm
Microsoft Servers - Textual Searches on File Data White Paper - SQL Server 7.0
http://www.microsoft.com/SQL/techinfo/P72014.htm
http://www.microsoft.com/SQL/techinfo/filedata.htm
Regards,
Andrew.
by patrick
Thanks a lot, sorry for the slow response!
by patrick
This question was closed by the author
This discussion is closed to new replies.
Trending Networks posts
Sort by Trending
Question Unanswered
How Can IT Teams Detect Hardware Bottlenecks in Business Networks?
0 helpful
0 replies
Question Locked
Using multi-NIC setup for NAS + router — better than VLAN?
0 helpful
4 replies
0 helpful
5 replies
Question Locked
Unknown device connected to my network
0 helpful
2 replies
Question Locked
How to change public IP without ISP?
0 helpful
2 replies