Results 1 to 2 of 2

Thread: MSSQL 2005 - Full Text Indexing?

  1. 10-07-2009, 09:34 AM #1
    ecka00
    ecka00 is offline Registered User
    Join Date
    May 2005
    Posts
    111

    MSSQL 2005 - Full Text Indexing?

    Will SQL allow full text indexing on a field with a "text" datatype? If so, what is the syntax to create a full text index on the following:

    db name: Gator
    table name: InboxResult
    field name: RawHL7
    Reply With Quote Reply With Quote
  2. 10-07-2009, 11:22 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You can create full test index catalog with wizard in ssms, or find syntax of 'create fulltext catalog' and 'create fulltext index' in books online.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules