What are the challenges you face when working across database platforms? Take the survey
Options

Script object as alter not enabling fulltext index

meyerovbmeyerovb Posts: 21
edited May 13, 2011 11:25AM in SQL Prompt Previous Versions
Create an indexed view, add a automatically change tracked full text index to it, write a select statement against it, right click on the view name, script object as alter. Notice the last lines create the fulltext index with change_tracking off and adds the columns to it, but the full text index is never set to change_tracking auto.

Comments

Sign In or Register to comment.