Tim Maxey .NET Technology Blog & Resources

Full Text Index on SQL Express

On SQL Express I had to do the following to get FULLTEXT index setup. I also had to make sure there was a primary key, then I went to the design of the table and right clicked on the primary key (or any colum) and select the fulltext index, when the dialog came up on the right side I selected the columns I wanted to add, click close and I was set...

use mydatabase

exec sp_fulltext_database 'enable'
exec sp_fulltext_catalog 'tblMyTable', 'create'


No comments posted yet.

Post a comment


Please add 5 and 7 and type the answer here: