create full text index on 2 column of same table

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

create full text index on 2 column of same table

Author

Topic

bluestar
Posting Yak Master

133 Posts

Posted - 2008-09-17 : 13:04:16

hello

how to create full text index on two columns of a same table.

this is what I have done for one column of a table SystemElement.

CREATE Unique Index ui_SystemElement on SystemElement(SystemElementID)
Create fulltext index on SystemElement( SESummaryText TYPE Column Text )
Key index ui_SystemElement on charlottecatalog
with change_tracking auto

but when I am trying to create index on another column of the same table

Create fulltext index on SystemElement( SETitleText TYPE Column Text )
Key index ui_SystemElement on charlottecatalog
with change_tracking auto

its giving me error saying
A full-text index for table or indexed view 'SystemElement' has already been created.

james_wells
Yak Posting Veteran

55 Posts

Posted - 2008-09-17 : 16:13:18

Only one full-text index is allowed per table.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources