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 |
|
loki13
Starting Member
5 Posts |
 Posted - 2011-09-20 : 10:05:19
|
| Hi,I never used full-text search before and want to start using it because our stardard LIKE text search is very slow.However I am not able to create a table index and set its "Is Full-text key" property to Yes.The index is on a unique bigint column with identity.The database is full-text enabledWhat should I do to be able to set my full-text index ?thanks |
|
|
jhnegrao
Yak Posting Veteran
81 Posts |
Posted - 2011-09-22 : 17:17:51
|
| Hi,First of all, have you created the Full Text Catalog to this Index?Go to <Database> -> Storage -> Full Text Catalog.As soon as you have this catalog configured, you will be able to use it.Don't forget to create a job to re-populate this index frequently. |
 |
|
|
|
|
|
Enabling Full-text search