This would save me the redundant
ON MyCatalog phrase when I create full-text indices.
CREATE FULLTEXT INDEX ON MyTable ( MyField1, MyField2, MyField3 ) KEY INDEX PK_MyKey ON MyCatalog /* I want MyCatalog to be default, so I don't have to specify*/ WITH CHANGE_TRACKING AUTO
MyCatalog set as default catalog, I wouldn't have to specify
ON MyCatalog every time I want to create a full-text index. So how can I make MyCatalog default on this database?