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
add comment

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.