I'm facing a strange problem: Everytime I make changes in tables (e.g. adding a column, altering a column's datatype, renaming a column, etc.) my full text catalog is being destroyed the moment I press "Save" in the SSMS.
After that, SSMS's properties dialog of the full text catalog shows a catalog size of 0 MB and an item count of 0. The only option I have after this is to rebuild the catalog.
Has anyone experienced the same or a similiar problem?
Some additional info: SQL Server 2008 R2, SQL Server 2016 Management Studio
Thanks in advance and greetings from Austria! :)
SiJayBe