I need to develop a search engine which searches for a string/strings in the SQLserver database. What is the best way to do it.
We are using XML for data transfer, COM objects for talking to database and XSL for converting to HTML reports. But the reports are not stored in a directory. So we cannot use normal search done on page content. we have no other option but to use database search.
