How can we help you today? How can we help you today?

Script object as alter not enabling fulltext index

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.
meyerovb
0

Comments

2 comments

Sort by
  • Anu D
    Thanks for your post.

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

    SQL Prompt 5 --> Refresh Suggestions
    Anu D
    0
  • 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
    meyerovb
    0

Add comment

Please sign in to leave a comment.