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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-12 : 09:37:47
|
| Pawan writes "Sir Thanks in advance! on our site we are using SQL SERVER 2000.we want to give the facility of "Full text search".This is working fine at our local machine but not on our server.will u guide us one-by-one step to do this? We are searching from around 15 tables and in tables we are storing HTML code of every page of sites..Waiting for a quick and positive reply.RegardsPawan" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-03-14 : 20:52:40
|
| Well, I don't have a step-by-step answer for you here, but I'll give you a couple of keys to look at. If you have it working on your local machine, then you know the basic steps to get it working on your production server. First, the option for Full-Text indexing has to have been installed. Second, if you are using Enterprise Manager to build the catalogs, you have to use the Enterprise Manager that is ON THE SERVER you are working on. You can't use EM remotely to do this. But you can use Query Analyzer remotely to do it. Third, if you have migrated your database from SQL 7 to SQL 2000, you need to re-enable Full Text indexing on the server by executing sp_fulltext_database 'enable' or something really close to that.------------------------GENERAL-ly speaking... |
 |
|
|
|
|
|
Full Text Search