SQL tips for database administrator RSS 2.0
# Thursday, 18 December 2008

1.       Enable Full Text Search

a.       Open the database project

b.      Right Click the database project then select properties

c.       On the Project Settings tab, make sure the Enable full text search option is checked

2.       Create Full Text Catalog

a.       Under Solution Explorer , expand the Database project, expand the Schema Objects -> Storage

b.      Right click the Full Text Catalogs, then select Add -> New Item from the context menu

c.       Select Storage from Categories panel then select Full Text Catalog from Templates panel

d.       Enter the name of the Full Text Catalog you are creating.

e.      Enter the creating Full Text Catalog script in the script window then save.

CREATE FULLTEXT CATALOG {FullTextCatalog_ReplaceThisName}

ON FILEGROUP [PRIMARY]

WITH ACCENT_SENSITIVITY = ON

AS DEFAULT

AUTHORIZATION [dbo]

3.       Create Full Text Index on a table

a.       Under Solution Explorer, expand the database project->Schema Objects -> Table

b.      Right click the Indexes folder and select  Add New Item

c.       Select Tables and Views from Categories panel then select the Full Tex Index from Templates panel

d.       Enter the name of the Full Text Index then enter creating Full Text Index script in the window and save it

CREATE FULLTEXT INDEX ON {TableName} KEY INDEX {IndexKeyName} ON {Full Text Catalog Name}

ALTER FULLTEXT INDEX ON {TableName} ADD ({ColumnName})

GO

ALTER FULLTEXT INDEX ON {TableName} ENABLE

 

Thursday, 18 December 2008 03:03:01 UTC  #    Comments [0] -
TFS Database Project | Full Text Search
Comments are closed.
Archive
<2017 June>
SunMonTueWedThuFriSat
28293031123
45678910
11121314151617
18192021222324
2526272829301
2345678
Statistics
Total Posts: 6
This Year: 0
This Month: 0
This Week: 0
Comments: 2
All Content © 2017, Full Time DBA