Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

This would save me the redundant ON MyCatalog phrase when I create full-text indices.

For example,

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

With 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?

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.