Post reply

Code sample needed for creating full-text index on specific filegroup

  • April 8, 2011 at 10:31 am

    #235309

    Can anyone spare a code sample of creating a full-text index on a specific filegroup?

    I'm trying to follow BOL (http://technet.microsoft.com/en-us/library/ms187317.aspx), but the following sample does not parse:

    USE AdventureWorks2008;

    GO

    CREATE FULLTEXT CATALOG ftCatalog;

    GO

    CREATE FULLTEXT INDEX ON HumanResources.JobCandidate(Resume)

    KEY INDEX PK_JobCandidate_JobCandidateID

    on [ftCatalog], FILEGROUP PRIMARY;

    GO

    Msg 102, Level 15, State 1, Line 3

    Incorrect syntax near ','.

    Fails here:

    ...

    on [ftCatalog], FILEGROUP PRIMARY;

    This is frustrating...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • April 8, 2011 at 11:25 am

    #1309314

    OK, I started a profiler trace and created an fts index on Management Studio. Turns out I was forgetting a pair of parentheses...

    Should be:

    USE AdventureWorks2008;

    GO

    CREATE FULLTEXT CATALOG ftCatalog;

    GO

    CREATE FULLTEXT INDEX ON HumanResources.JobCandidate(Resume)

    KEY INDEX PK_JobCandidate_JobCandidateID

    on ([ftCatalog], FILEGROUP [PRIMARY]);

    GO

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply