Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQL-Newbie
Starting Member
2 Posts |
 Posted - 2005-09-06 : 21:22:39
|
| Hi All,I am pretty new to SQL and would like a bit of friendly help, please. Am trying to set up a .Net web site that will have dynamic content supplied by a true SQL server (am using MSDE to build this first).My issue is in building a search engine on my web site that will return hits from the content of the pages which are loaded in MSDE.Is there a third party or open source search engine available?Any clues for how to build (or beg, borrow or steal) a workable search engine to do this?Many thanks,Newbie |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-07 : 02:38:01
|
| Hi SQL-Newbie, Welcome to SQL Team!Are you wanting a "Full Text" search across the content of records you will store in a table in your database?If so this is built in to SQL Server - have a look in Books Online under "full-text catalogs, overview"Kristen |
 |
|
|
HCLollo
Starting Member
49 Posts |
Posted - 2005-09-07 : 03:44:58
|
Hi SQL-Newbie!  Well, it mostly depends on the kind of research you need todo on your pages: based on the text in the pages themselvesor on the data the pages are going to display?HCL"If it works fine, then it doesn't have enough features" |
|
|
|
SQL-Newbie
Starting Member
2 Posts |
Posted - 2005-09-11 : 22:34:48
|
| Hi Guys, thanks for the pointers. We are trying to search not just the text in tables, this may be the content of stored objects in different formats, PDF, DOC, PPT etcThat's why the problem, I kn ow e can search the database itself, just not sure how to do the binary stored objectsMany thanks, SQL-Newbie |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-12 : 01:19:47
|
| I'm pretty sure that Full Text Search can search, say, a descriptive column in the database and the contents of an external file (i.e. where the path/filename can be deduced from data stored in the database)Kristen |
|
|
|
|
|
|
|
|
3rd Party Search Engine web to SQL?