Exam 70-432: Week 1 - Still More Lab Exercises

These are from Chapter 5, Lesson 1 of the Lab Manual:

Practice 1 Create a Full Text Catalog

Step 1:

alter database AdventureWorks
  add filegroup AWFullTextFG
go

alter database AdventureWorks
  add file (name=N'AdventureWorksFT',
      filename=N'C:\TK432\AdventureWorksFT.ndf')
      to filegroup AWFullTextFG
go

Command(s) completed successfully.

Step 2:

use AdventureWorks
go

create fulltext catalog ProductsFTC
  on filegroup AWFullTextFG
 go

Command(s) completed successfully.

Practice 2: Create a Full Text Index

Step 1:

create fulltext index on Production.ProductDescription(Description)
    key index PK_ProductDescription_ProductDescriptionID
    on ProductsFTC
    with change_tracking=AUTO
go

Command(s) completed successfully.


Steps 2-4: