Script object as alter not enabling fulltext index

meyerovb

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.

Anu D

Thanks for your post.

Have you refreshed the cache after doing the changes to the Object?

SQL Prompt 5 --> Refresh Suggestions

meyerovb

Yes, I refreshed the cache before scripting object as alter, please attempt to reproduce and let me know if you see the same issue.

thanks