I am using SQL 2005 and SQL Server Management Studio.
How can I activate FullText in my database?
Or should I do this only for the tables where I need it?
How can I do this?
Thank You,
Miguel
Try the thread below I have posted most of the information you will need and why it may not work in Express and if you are in Express the second thread covers some work around solution. Hope this helps.
http://forums.asp.net/thread/1460813.aspx
http://forums.asp.net/thread/1446828.aspx
Hello, I have a database that has Full Text Search it works great under Management Studio Express. I can use the CONTAINS expression no problem.
Now when I try using the same database in Visual Studio 2005 the CONTAINS statement it doesn't return any values and I don't get any error messages.
The way I call my database from my web.config file is as follows:
<add name="MyDB" connectionString="Data Source=.\FULLTEXTSEARCH;Integrated Security=True;AttachDBFilename='D:\My Documents\Visual Studio 2005\WebSites\App_Data\MyDataBase.mdf';User Instance=false" providerName="System.Data.SqlClient"/
Why doesn't Full Text Search work when I use it from my web application and it does work under SQL Server Management Studio Express?
Please help,
Louis
Me again, I do get an error message when I try to run a query in Visual Studio 2005, namely:
Full-Text Search is not installed, or a full-text component cannot be loaded.
But it works just fine in Management Studio Express.
|||
I figured out my on problem. I was running the wrong database, my bad.
My host does allow me to create full text catalogs. I use SQL Server Management Studio Express, so I'd have to do it "by hand" as opposed to point-clicking menus and going through wizards. Where do I go to find those commands? I've seen them before but I can't remember where to get them. They're the ones that begin with sp_.
I need the commands for:
Creating a full text catalog
Specifying which columns and tables to enable full text searching
Scheduling when to update the catalog (when to repopulate, etc.)
Clearing the catalog to start over again
Any other handy/necessary commands?
Any help will be appreciated. Thank you.
i sent you that info here:http://forums.asp.net/t/1127286.aspx
|||
i sent you that info here:http://forums.asp.net/t/1127286.aspx
|||
That's creating the catalog and enabling table/column for full-text. I got those.
What about for scheduling population?
|||1. Activate your database for full-text search:
sp_fulltext_database 'enable'
(Warning! An already existing index will be reset to the default settings.)
2. Create the full text index: To continue, a so-called catalog must be created:
sp_fulltext_catalog 'Fulltextcatalog1','create'
('Fulltextcatalog1' is the name of the catalog for this example)
and a virtual index:
sp_fulltext_table 'Employee','create','Fulltextcatalog1','pkID_Field'
(pkID_Field is the name of the Primary Key of table Employee.)
3. Add the fields that you want to be indexed:
(The fields have to be either the type char, varchar, nchar, nvarchar or text.)
sp_fulltext_column 'Employee','lastname','add'
sp_fulltext_column 'Employee','firstname','add'
where 'lastname' and 'firstname' are the field names used in this example.
4. Next you have to activate the index:
sp_fulltext_table 'Employee','activate'
5. After that the index can be generated with the following command:
sp_fulltext_table 'Employee','start_full'
6. Now activate the 'Change Tracking'. Required for this, is a field with the data
type 'timestamp'. Through this, the newly created index will automatically be
updated, as soon as the data in the columns has been changed.
sp_fulltext_table Employee, 'Start_change_tracking'
sp_fulltext_table Employee, 'Start_background_updateindex'
Deleting Full-text Indexing on a table named fulltext1
1. First delete the index:
sp_fulltext_table 'Employee', 'drop'
2. And then the catalog:
sp_fulltext_catalog 'fulltextcatalog1','drop'
